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

[Vikram212 (Vikky)]

Hi

I am looking for some of the best ways to handle (reading and processing) 1million records present in excel

I only remember of this approach :-
Read range
For each row

but is there any other alternative approach other than this
because excel might get hang/crash if we use above method

Thanks

[pattyricarte (Patty Boy)]

Hi @Vikram212

Please read the article below for your reference.

https://www.skcript.com/automation/benchmarking-uipath-performance-using-multiple-bots/

cheers

Happy learning

[AshwinS2 (Ashwin S)]

Hi @Vikram212

Check this for your reference

Approach Manipulate excel with 10000 plus records

Have any one tried maniupulating excel with more than 10000 transactions in a file. I want to understand on the datatable performance and will it be slower than macro

Thanks
Ashwin S

[Palaniyappan (Forum Leader)]

Hi
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

Want To Know Excel Limitation for Uipath

Hi Omkar, MS Excel itself is limited to 1,048,576 rows by 16,384 columns. While I never seen a worksheet with so many columns, it’s not that uncommon to have many rows, even close to the limit. As you know, the UiPath Studio comes by default with two sources for Excel activities: App Integration → Excel activities System → Workbook activities For large excel files, I recommend you to use the App Integration Excel activities (those that require an Excel Application Scope). The activit…

Cheers @Vikram212