How to delete a range of cells in excel which is filtered by two columns

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 ?

Welcome to UiPath community
Do you need to delete cat 1 column?

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,

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)

Hi @Muthu_Selva_Karthikeyan

Can you share the Output as well it would be great

Hi @Muthu_Selva_Karthikeyan

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


Doubt in Uipath.xlsx (9.6 KB)

Hi Gokul, Please look into the attachment

Hi @Muthu_Selva_Karthikeyan

This is how you can achieve it

XAML for reference
Modify.xaml (11.0 KB)


Hi @Muthu_Selva_Karthikeyan

Check out this XAML file

ForEachRow.xaml (9.2 KB)


Output :


Thank you So much for your help and your xaml file.

Thank you So much for your help and your xaml file. Cheers too.

1 Like

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.