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 ?

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 [image] Forum FAQ - How to mark a post as a solution Tutorials Forum FAQ - How to mark a post as a solution This document is part of our…

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

Help Studio

Anil_G (Anil Gorthi) November 29, 2022, 7:42am 7

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

cheers

Topic		Replies	Views
How to delete excel rows based on filter? StudioX studiox , question	2	1260	June 11, 2023
After applying the filter on excel, I want to delete the the filtered column Studio excel , studio , question , activities_panel , filter , delete	9	3818	December 21, 2023
Deleting filtered data in column Studio studio , question , activities_panel	3	364	December 21, 2023
Delete rows in Excel based on column data Studio excel , studio , question , activities_panel	3	547	December 26, 2022
Based on Filters Delete Record from Excel Studio datatable , excel , studio	10	1140	May 14, 2020

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

Related topics