Pivot table in excel using UIpath

Question

Heelo how to make a pivot table using UIpath?

Is there a way to make a pivot using UIpath?

please help

Answer 1

You can do it in two ways :

1. Macro. Record macro and use "Execute macro" activity in the uipath

2. UI Automation

Answer 2

using create pivote table activity.

Answer 3

Using UI Automation you can create pivot by
selecting the data to make pivot using 'select range' activity. Then using send hotkey, pass Alt+N+V+T (Will open the pivot dialog box) Now, select the row,column etc again by using find element or find image and drag and drop to required fields.
The Drag and drop can be done by using a combination of'click up' and 'click down' property in click activity.
Hope this helps

Answer 4

You can use Create Pivot Table activity to create pivot table from any excel sheet. You just have to mention the source table name and the range where you want the pivot table to be created.