Reading large Excel files - out of memory

[badita (Mihai Badita)]

The way to go with this is to read your file in batches of, let’s say, 50k rows.

How to delete a row in excel using invoke method

Either you read a column or an entire range it is recommended to use Excel Application Scope. Reading very large Excel files has a nice solution: do it in chunks of 10000 rows. Read A1:C10000, then A10001:C:20000 and so on until you get less than 10.000 rows in the resulting datatable. I don’t quite get what are you trying to do with the file. Is that a file on disk, an Excel file, some rows in Excel…