How to read pivot tables sheets in excel


#1

Hi All,

I have a requirement in which i want to read all pivot tables in my excel (like i have 20 pivot table sheets with each country name ) on the basis of a “main” sheet that contains country data .

i have attached a example sheet . (in real i have around 20 pivot tables in one excel with sheet name same as country name )

So , like one pivot table sheet for each country . I need to search amount present in main sheet with each country pivot table sheet ( if its present , i need to populate one column in main sheet)

How to do that ?

I have to looPivot_Read.xlsx (17.0 KB)

Regards
Ankit


How to filter in Pivot table of Excel
#2

Hi ,
Use get table range activity to read pivote table and for the rest you can achieve by filtering sheet .
https://www.uipath.com/activities-guide/excel.table.get-table-range


#4
  1. Pivot Table - Works with or without Excel Application Scope.
  2. Filter Range / Data - Works with or without Excel Application Scope.
  3. Find & Replace - Advanced Technology. (See the video)
  4. Text to Columns - Fixed width & Delimiter.
  5. Copy paste data - To same workbook or to other workbook without any format loss.
  6. Remove Duplicates - Single / multiple columns.
  7. Update Status in an Excel sheet after processing some invoices or any (Completed, Success, Closed, etc)
  8. Clear contents - To delete / clear the data of a given column.(See the function lists in drop-down)
  9. Excel Save as - To save the excel in different format (.xls to .xlsb OR .xlsm to .xls)
  10. Cells Formatting - To set the columns in a required format (General, Text, Number or any custom format)
  11. Export PDF to Excel.
  12. Export Notepad to Excel.
  13. Extract specific lines from Notepad and paste into an Excel.
  14. Extract specific lines from PDF and paste into an Excel.

All activites under custom activities in : - https://uipath.devpost.com/submissions
Kindly go through each of the activities…