What are best ways for reading and processing 1million records present in excel

Excel itself is limited to 1,048,576 rows by 16,384 columns and for arge excel files, I recommend you to use the App Integration Excel activities (those that require an Excel Application Scope).
Only activities from Workbook might throw exceptions when working on large excel files.
for more details on this

Cheers @Vikram212

1 Like