Pivot table in Excel
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
05-08-19 07:10 AM
Hi ,
I have a requirement to get a pivot table from excel data, how to get it. Please help me. Do we have any VBOs?
------------------------------
Murali Mohan Konanki
Sr.Automation Specialist
S&P Global
UTC
------------------------------
I have a requirement to get a pivot table from excel data, how to get it. Please help me. Do we have any VBOs?
------------------------------
Murali Mohan Konanki
Sr.Automation Specialist
S&P Global
UTC
------------------------------
1 REPLY 1
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
18-09-19 06:19 AM
Hi Murali,
You will have to create a custom action in the Excel VBO preferably using code stage. More info on pivot table object can be found here https://docs.microsoft.com/en-us/office/vba/api/excel.pivottable
------------------------------
Shashank Kumar
DX Integrations Partner Consultant
Blue Prism
Singapore
+6581326707
------------------------------
You will have to create a custom action in the Excel VBO preferably using code stage. More info on pivot table object can be found here https://docs.microsoft.com/en-us/office/vba/api/excel.pivottable
------------------------------
Shashank Kumar
DX Integrations Partner Consultant
Blue Prism
Singapore
+6581326707
------------------------------
