How to read only specific row from Pivot table and write in another workbook-Sheet1?

Hello experts!

The scenario is: I have a excel file AKA “abc” and need to read one row that consists of number of columns, lets say [ number of specific document.], copy single number at a time and write in AKA “xyz” excel workbook Sheet1 by checking some conditions.

1 Like


We can use GET TABLE RANGE activity where mention the range of table or row and enable Is Pivot

Have a view on this for more details

Cheers @Prabin_Chand


Hello @Prabin_Chand ,

It would be better if you can provide some screenshot of your requirement.

If you just need to get all the data from the pivot, either you can use Read Range activity or if you need to keep the format of the Pivot then you can use Get Table Range.

1 Like