Reading Excel File

Help
, ,
1

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

2

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
3

@iVishalNayak,

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

1 Like
4

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

cheers :smiley:

Happy learning :smiley:

2 Likes