I have a pivot like this
I need to:
- copy the pivot table only (without the source data) including string at the A1
- paste it to another workbook (contain few different existing data) starting from A3 (dynamic).
I tried read range but it’s not working as the pivot cannot be read normally. Most topics in forum suggesting copy sheets but it doesn’t work on me as I need to paste it into a sheet that already have data.
Please try using Get Table Range and pass the pivot table name to this activity it would read whole of the pivot table
To copy a pivot table and paste it into another workbook in UiPath, you can use the following steps:
- Open the workbook containing the pivot table you want to copy.
- Select the pivot table.
- Use the
Copy activity to copy the selected pivot table to the clipboard.
- Open the destination workbook where you want to paste the pivot table.
- Use the
Paste activity to paste the pivot table from the clipboard into the destination workbook.