Hi, Can I get data from Pivot Table into a DataTable in UiPath? I need to iterate through each row in the pivot table to do some data processing. Thanks for your feedback.

Yes, you would use the Read Range activity to read the Excel tab that has the pivot table. [Pivot table screenshot] Read from Excel Files The example below explains how to read information from a row or a column, inside an .xlsx file. It presents activities such as Read Row and Read …

Pivot to DataTable

Help Activities

aman.sharma1 (Aman Sharma) May 26, 2022, 9:40pm 2

Yes, you would use the Read Range activity to read the Excel tab that has the pivot table.

1 Like

How can i check bottom pivot table in excel to check if Payroll Name exist?, if exist how to check if it is blank or not? if eixst then do some operations , if exist but blank then do some operations, doesnot exist then do some operations

Topic		Replies	Views
Read Pivot table source data Activities excel	4	2525	October 27, 2021
Pivot Table questions Activities datatable , excel , activities , studio	1	643	May 16, 2022
How to read data from pivot table Help excel , studio	6	3615	November 6, 2023
How to read data from Pivot Table in excel file Studio uiautomation	1	682	June 2, 2023
How to read only specific row from Pivot table and write in another workbook-Sheet1? Activities datatable , excel , uiautomation , robot , activities , studio , studiox , question , activities_panel	2	1329	May 21, 2022

Pivot to DataTable

Related topics