Dear Team,

Thank you for your support.

Use the Excel Create Application command to open your Excel workbook. Use the Excel Create Pivot Table command to create a pivot table based on a specified range or table within Excel - I have used this command for generating the Pivot in Excel. I have some suggestions here; it would be great if you add some of the additional fields to the create Pivot table command, like Filters, Columns, Rows and Sum of Values so that Developers can add the required columns to the respective Pivot table creation.

Alternatively, you can use Use Invoke VBA or Execute Macro command to generate the pivot table - Could you please help me from where I could see Invoke VBA Command?

Thank you.

Hello Faheem,

OpenBots provides Excel commands that simplify working with Excel files, including creating Pivot Tables. Here's a simple step-by-step guide:

Read the Excel File:

Use the Excel Create Application command to open your Excel workbook. Use the Excel Create Pivot Table command to create a pivot table based on a specified range or table within Excel.

Alternatively, you can use Use Invoke VBA or Execute Macro command to generate the pivot table.

Best regards, Support Team