How to find and remove filter option while writing the data into excel

[Kunal_Jain]

I have an excel sheet that is a template and is updated everyday.
So sometimes the excel sheet filter option remain in which hides the rows from the sheet and due to which process goes into error.
How to resolve it.
I have attached screen shot for the same

How to solve this problem?
Thanks in advance!!

[adiijaiin (Aditya Jain)]

Hi @Kunal_Jain

If you are using Excel Application Scope and then Read Range,
Please check for this property UseFilter, it should be unchecked,
and when you read the data. it should give you all the records.

Thanks

[Anil_G (Anil Gorthi)]

@Kunal_Jain

Try using filter activity and check cleae filter option…

Any filters will
Be cleared

Cheers