Excel Pivot and Graph configuration Automation

[D_Okthree (Dof)]

Hi Experts,

I have questions about Excel automation. It’s about pivot table and graph.

1. I know that UIPath can automate pivot table creation (create pivot table activity).
   However this is a very raw pivot table and in my case I have to configure the pivot table. In Excel we do manually through this panel:

2. Automate graph creation.

How can we automate this in UIPath? Is there any activity package that support this? Or do we just use UI automation?

Please advice. Thank you.

[Yoichi]

Hi,

The latest preview Excel package : UiPath.Excel.Activities Packagev2.10.0-preview includes some new activities for chart (and pivot table) as the following image. Can you try them?

Although it’s for StudioX, we can also use them in Studio. Please make sure to check Show StudioX at filter settings in Activities panel.

Regards,

[D_Okthree (Dof)]

Hi,

Thank you. I think this should be the answer.
However, I can’t find in those StudioX Excel activities though I have installed the latest version UIPath.Excel.Activities Package 2.10.0 preview:

My studio version is

Is the version is not compatible or any other issue?

Thank you.

[Yoichi]

Hi,

Can you check your filter settings of activities panel? (Show StudioX should be checked)

Regards,

[D_Okthree (Dof)]

Hi,

I see. It works now. Thank you.