Handling Huge Excel Data for Processing

Help Studio
, ,
1

How can you optimize the performance of a UiPath robot that processes a large volume of data in Excel files?

2

Hi @Chitturi_Keerthi_515 ,

To optimize performance, use the Read Range activity with the “PreserveFormat” property set to False, as this speeds up the reading process.
Consider using the Workbook activities instead of Excel activities,
as they don’t require Excel to be installed and are faster.
Also, process data in chunks rather than reading the entire file at once.

Regards
Happy Automation

3

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.