I have a an Excel file that is 4.73 MB in size. It has 11 columns and 77881 rows. I am using these dependencies in my project:
I intend to read the Excel into a datatable and then later use that Datatable to do VLookup with other datatables.
However, it is taking a long period of time to read the aforementioned Excel. I have never faced this problem before. The last time I ran t VLookupSphere.xaml (70.5 KB)
he process, it took 10 minutes, before I stopped it. Is is normal, I don’t remember it being this long.
My Excel Application Scope properties are as follows:
You can use the read range workbook activity instead of using Excel activity to read Excel and store in a datatable. The read range workbook activity doesnt take much time than excel activities. Give a try with it.
Is it slow in debug, or in run? I have found this happens only during debugging, only if certain debugging options are enabled.
Running the file instead of debugging does not have the same issue.
Turning off all the debug options fixes the issue - Slow Step, Execution Trail, Highlight Elements, and Log Activities - I can’t remember which combinations cause Excel to slow down on debug, so I just turn them all off.