Excel Application Scope - Instance Cache Period

Help
1

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.

2

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

3

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.

2 Likes