Excel Application Scope - Instance Cache Period

I wanted to find out what the option InstanceCachePeriod is used for and whether it needs adjusting for a large Excel file. I was unable to find this option listed in the UiPath Documents repository. Can anyone clarify? Also what is best practice for a large Excel file - its 100k rows and 10MB.

Hi @ChrisC,

Excel file can read using Read range activity to get a output of a DataTable. When dealing with large data don’t use loops, instead of loop use LINQ queries to resolve business purpose

Thank you. Do you know what the cache option is used for and whether and when the value should be amended? I can’t find it in the documentation.