Reading Excel File

Which is the best method to read excel files having large number of records (1000000 records)?
whether it is using code or excel application scope.?

Hi @iVishalNayak

Depends on what operation you’re going to do.

If you want to do some excel oriented tasks like cleaning and transformation you can use Excel Macros since they are super fast.

But if you want to extract the data and use it for any API Call, you can read it to Data table and perform. But for that huge data set it’ll be pretty slower.

1 Like


Excel Application Scope will be the best option, try with that.

1 Like

Based on my experienced Excel application scope is much better than @iVishalNayak

cheers :smiley:

Happy learning :smiley: