Getting a pivot table's data and pasting it into another worksheet?


#1

Hi, I’ve been trying to put a filtered pivot table from a source spreadsheet into a reconciler spreadsheet. However, the way UiPath can fetch Pivot Table data is through a “Get Table Range” activity, which stores the variable as a string and not a datatable. Is there a way to store it and then paste is as a data table or any way to extract the table’s data without it running into an error? Or do we need the data to be in a standard Excel range?

Thanks,
Ian