Hi All, I need to Switch off the Filter in an excel if Filter is applied in that Excel, Else nothing to perform. So My question is How to Use If else Statement for that Excel for Filter?? Could Any one please suggest?

@keshav its very simple, one click can solve this yes…whenever you read a excel file with open application scope and followed by read range activity, we have an option in read range activity called “USE FILTER” property…this will be usually diabled,so when you read file with read range being this p…

Switch off the Filter in an excel

Help

Arunachalam (Arunachalam) May 2, 2019, 2:13pm 2

@keshav,

Can you please share me your logic so that i can give a solution for that. meanwhile, I have created one sample workflow with filter the duplicate name in Excel file using if else statement inside For each activity (Without Filter Activity).
DuplicateRecordsCheck.zip (213.1 KB)

Thanks,
Arunachalam.

1 Like

Remove the Filters from the Excel Using UIPATH

Topic		Replies	Views
Remove the Filters from the Excel Using UIPATH Activities excel , activities , question	1	856	August 2, 2022
Excel -filter condition s Help	6	822	May 15, 2019
Remove filter from excel sheet Activities excel , orchestrator , activities , question	30	1327	February 7, 2023
Remove filters from excel file Activities datatable , excel , uiautomation , studio , question	7	258	September 18, 2023
Excel filter problem Activities datatable , excel , activities , studio , question	4	265	September 17, 2023

Most Active Users - Yesterday
ashokkarale
MD_Farhan1
Ajay_Mishra
postwick
Dheerendra_vishwakarma
Anil_G
chandreshsinh.jadeja
Gautham_Pattabiraman
vrdabberu
aravindbalineni123
More details...

Switch off the Filter in an excel

Related Topics