How to use create pivot table activity and save the new pivot table in new sheet

[Rawan_Ghurab]

How to use create pivot table activity and save the new pivot table in new sheet

[arjunshenoy]

Hi @Rawan_Ghurab

The following resources might help you with the same:

https://forum.uipath.com/tag/pivot

Pivot tables

Hi, Is it possible to do Excel pivot table activities using Uipath? Looks like Uipath is limited to creating and refreshing pivot tables. Are there alternate ways of doing pivot table functionality using Uipath? Thanks so much,

Hope this helps,
Best Regards.

[Vishnuraj_Pandiyarajan2 (Vishnuraj Pandiyarajan)]

Hi @Rawan_Ghurab
If you want to create pivot and save into another sheet
first u need to create the sheet datas to Table then only u can use pivot table activity

Please refer the video the better understanding

UiPath Tutorial | Uipath Pivot Table | Uipath Excel Automation Chapter 2 (2020)

Note:
even u can use code without using pivot datatable for extract your requriment if we get sample data for the Input and ouput

Thanks
VP