Hi Team, I have a doubt would anybody please help me to solve.
In excel file, I have applied filter in column “Cat1” and second level filter in next column “Cat2” after applying filter now I want to delete the visible cells for each row in column “Cat1”. How to do the same in UiPath ?
To remove all the filters from a table or range. Select any cell inside your table or range and, on the Data tab, click the Filter button. This will remove the filters from all the columns in your table or range and show all your data.
This May Work,
Peter
Not the entire column only the data which are visible under cat1 column. I have attached one excel for your better understanding.
Doubt in Uipath.xlsx (9.6 KB)
Hi Peter thank you for replaying, i have attached one excel for better understanding of my question. Please look into that and help me out for this
Doubt in Uipath.xlsx (9.6 KB)
Please read the data into datatable and use filter datatable and then paste the data back to excel. Before pasting make sure you delete whole range so that new filtered data will be present in the Excel
cheers
Thank you So much for your help and your xaml file.
Thank you So much for your help and your xaml file. Cheers too.
If you don’t have any further question, Kindly close this topic by mark as solved it will help for other too. @Muthu_Selva_Karthikeyan
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.
Anil_G
Yoichi
Chirag_Shetty_Divakar
supermanPunch
fernando_zuluaga
Pavanraj_Shetty
Mohammad_Irfan
Muhammed_Sahil
Gvivek9889
mohan_sai365