How to filter in Pivot table of Excel

[Arielzhang]

I would like to filter column in Pivot table. If I put the excel into datatable in Uipath. The format will change.So I need to sort directly from Excel Pivot Table. Does anyone know how to do it?

[Prakshi_Tyagi]

did you find any solution for this?

[Sharanabasava (Sharanabasava Kallurmath)]

Hi,

Have u got Solution for this,if its there can u share the xaml file, Thanks

[JPOkawa]

Hi, please refer to this post.

How to read pivot tables sheets in excel

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 popul…