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
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.