Pivot Tables Excel and exporting to Powerpoint


#1

Vikas Jain
September 28, 2016 16:33 NONE
How can we do following

  1. Create Pivot table using another Excel sheet

2 Create a Pie chart with the values

3 Export to Powerpoint


How to use pivot table to get data from a spreadsheet to another
Excel graph to powerpoint automation
Pivot Tabale using UI Path
#2

Mihai Badita September 28, 2016 16:50
Possible now only via UI Automation. You can create a new sheet with UiPath by using the dedicated activities.

After that, some useful shortcuts:

A1 + Enter in namebox - go to A1
Ctrl+ Right arrow - go to the last column ov your table
Ctrl + Shift+ - Down to select the column
Ctrl + Shift+ - Insert a column.

Or more here: https://support.office.com/en-us/article/Excel-keyboard-shortcuts-and-function-keys-1798d9d5-842a-42b8-9c99-9b7213f0040f


#3

Vikas Jain September 28, 2016 17:55
It worked using combination of Key strokes along with Ui Automation.

Thanks!