Read range Modern activity

Help Studio
, ,
1

Hi Team,

I am using the Read Range (Modern) activity to read an Excel file with 1000 records, but it takes over a minute to complete. In contrast, the Classic Read Range activity processes the same file much faster.

Since my project is built with Modern activities, I want to continue using the Read Range (Modern) activity. Could you suggest any optimizations or best practices to improve its performance?

2

Hi @Naveen_Kumar6 ,

  1. Disable “Preserve Formatting”: If you don’t need to retain cell formatting, uncheck the “Preserve Formatting” option. Formatting conversion takes extra processing time.

  2. Specify the Exact Range Instead of “Auto”: Instead of reading the entire sheet (Auto), specify the exact range you need, such as "A1:Z1000". This reduces unnecessary processing.

  3. Use “Only Read Used Range”: If your Excel sheet has many blank rows, enable the “Only Read Used Range” option (if available). This will ignore empty rows, speeding up execution.

  4. Minimize Concurrent Excel Operations: Ensure that no other Excel processes are running in the background that may slow down access.

  5. Run UiPath in a Higher Performance Mode: If running in debug mode, try executing in normal mode as debugging adds overhead.

  6. Close Background Excel Instances: Use “Kill Process” (Excel) before reading the file to prevent interference from background Excel processes.

  7. Use “Workbook Path” Instead of “Excel Process Scope”: If you don’t need to interact with Excel after reading, use Workbook Path instead of keeping an Excel process open.

Regards,
Vinit Mhatre

3

Hi,

Can you try to set RawValue in ReadFormatting property and OFF in VisibleRowOnly property as the following?

image
image1248×694 34 KB

Regards,

1 Like
4

Hello @Naveen_Kumar6 here are some steps you should try to reduce time

  1. Set “Preserve Format” to False.
  2. Set “Detect Column Types” to False.
  3. Open the properties for “Read Range (Modern).”
    • Uncheck “Preserve Format.”
    • Uncheck “Detect Column Types.”
  4. Use “Excel Process Scope” at the beginning of the automation.
  5. In “Use Excel File,” choose “File mode” instead of using an existing Excel application instance.
  6. Instead of selecting the entire sheet with “”, specify the range “A1:D1000” if you only need certain columns.
  7. Open the “Excel Process Scope.”
  8. Verify if it is running in background mode.

please do needful if it work

5

Hi!

You could also consider using the Workbook Activities instead and see if that makes a difference
Activities - Workbook activities

Activities - Read Range Workbook

6

This is a known issue.

As a work around - Kindly check the below settings

Read Formatting should be Raw Value
Uncheck Visible Rows Only

image
image1480×292 41.9 KB

1 Like
7

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