Copy cells from dynamic Pivot Table

Help StudioX
11

@Youri98,

Ok here is sample code to refer.

I’m assuming you have file like this.

A pivot table in Excel summarizes sales, profit, and revenue data for entities ABC, AFG, and XYZ with their respective totals. (Captioned by AI)
A pivot table in Excel summarizes sales, profit, and revenue data for entities ABC, AFG, and XYZ with their respective totals. (Captioned by AI)801×366 7.55 KB

Code like this.

The image depicts a detailed flowchart of an Excel process automation script, which includes steps to read specific cell values and log messages. (Captioned by AI)
The image depicts a detailed flowchart of an Excel process automation script, which includes steps to read specific cell values and log messages. (Captioned by AI)879×2071 105 KB

Output:
The image shows the output log of a UiPath automation script indicating the successful execution of a PivotDemo using an Excel file, displaying some numerical outputs, and ending in 00:00:08. (Captioned by AI)

Sample code:
PivotDemo.zip (143.5 KB)

Thanks,
Ashok :slight_smile:

1 Like