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.
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.