Read Range in Excel Appliction scope taking too long to read

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:
image
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:
image

My Read Range properties are as follows:
image

Please do help me by advising me.

Hi @RobinsonFrancis

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.

Hope it helps!!

Hi @RobinsonFrancis

Option1:

Use Modern activities i.e., Read Range Workbook activity

Option2:

Use Excel Modern activities i.e.,

Excel Process Scope->Use Excel File->Vlookup

For Handle Large Excel Files:

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.

Unfortunately this is not happening during debug.