Studio Pivot Table Activities

[nicortak (Nico)]

Hi Guys,

I have a question regarding Excel Pivot Table Automation.
I can not find an activity in Studio Excel Activity to configure the columns and fields of the table however I found this tutorial on how to achieve exactly that in StudioX, so I was wondering - is there a respective activity in Studio or any tips on how to configure the Pivot.

StudioX Tutorial: Tutorial: Creating a Pivot Table (uipath.com)

Best regards and thanks already!

[kirankumar.mahanthi1 (Kirankumar Mahanthi)]

Hi @nicortak ,

Yes studiox have create pivot table activity for the business users. Currently we don’t have any activity related to creation of complex pivot tables. But we can use vb code and invoke code activity to achieve this requirement. Pls let me know any help on vb code to create pivot table I can share some sample code. Thanks.

[nicortak (Nico)]

Hi @kirankumar.mahanthi1,

thanks for your reply. I solved it using VB Code however was wondering if there is an easier way.

Best regards

Nico