How to create pivot table using invoke code

[Hitesh1 (Hitesh)]

Can someone help me with the code for creating pivot table.

Thanks,

[Srini84 (Srinivas Kadamati)]

Hello @Hitesh1

Why don’t you use create pivot table activity which comes with UiPath, If you want to work through invoke code only, u can refer below post for your reference

Is there a way to create pivot tables based on business rules?

Hi guys, Well he question is pretty self explanatory, I want to create multiple pivot tables with different filters based on business rules such as if a row contains the word application include it in the pivot table, etc. but the activity just allow to create simple full pivot tables.

Thanks

[SenzoD (Senzo Dlomo)]

@Hitesh1, the below might be helpful too:

Create Pivot Table UiPath | Refresh Pivot UiPath | Excel Automation UiPath in Hindi

Creation of Pivot Table

Hey guys, I wanna know how Pivot table can be created. I’ve just created a pivot table manually. And, I tried automating it with the activity, but getting errors. Test.xaml (5.6 KB) I need some help here. Thank you.

[Hitesh1 (Hitesh)]

I want to know which is the best approach to create pivot table, using activities or using invoke code

Thanks

[William_Blech_Sister]

Hy @Hitesh1,

If you are in UiPath do as it is done in UiPath!

If there i a default activity you must use learn how to use it

Regards

[Srini84 (Srinivas Kadamati)]

@Hitesh1

If we have a default activity provided with UiPath then we can use that, If that activity not met with your requirements then only we have to think on Invoke Code

Hope this helps you

Thanks