Pivot tables

[A_Learner]

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,

[Sudharsan_Ka]

HI @A_Learner

As far as i know we have activities only for Creating pivot table and Refreshing it .

Check on this link

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

Regards
Sudharsan

[Gokul001 (Gokul Balaji)]

Hi @A_Learner

You need to check the Show Modern

In the Modern → App Integration → Excel → Pivot Table

You can find the below activity

Have a look on the documentation

https://docs.uipath.com/activities/docs/change-pivot-table-data-source-x

https://docs.uipath.com/activities/docs/excel-create-pivot-table

Have a look on the video

UiPath Tutorial || Day 40 : Create Pivot Table and Refresh Pivot Table

Regards
Gokul

[A_Learner]

Thank you. I am wondering how pivot table filtering, grouping etc. can be done with Uipath. Thanks,

[Sanjit_Pal]

You can refer this video to create the pivot in UiPath

LINQ | LINQ Pivot | Create Pivot Table Using LINQ | LINQ Uipath | Uipath Tutorials | Coderslobby

[A_Learner]

Thanks for the correct pointer.