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 ?
@Muthu_Selva_Karthikeyan
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,
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)
Can you share the Output as well it would be great
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
Doubt in Uipath.xlsx (9.6 KB)
Hi Gokul, Please look into the attachment
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.
prashant1603765
ashokkarale
sharazkm32
yedukondaluaregala
TJamuna
pikorpa
sonaliaggarwal47
pavitra
yulax
SorenB