Modern Excel Read Range Activities Problem

Feedback Activities
, ,
1

There is a problem with Modern Read Range Activity. The problem is that when reading 30,000 excel rows with Classic Read Range Activity, it takes like 5 seconds. But with Modern Read Range Activity it takes more than 15 minutes… And it still doesn’t read. Isn’t Modern activities supposed to be faster than Classic?? Isn’t it supposed to be MODERN? I think UiPath software engineers should really take this into serious consideration…

3

Hi

If you are experiencing performance issues with the Modern Read Range Activity, you can try the following:

Update UiPath Studio to the latest version. UiPath is constantly releasing updates to improve the performance of its activities.
Use the Classic Read Range Activity for large Excel files. If you are only experiencing performance issues with large Excel files, you can switch back to using the Classic Read Range Activity for those files.

Thank you

4

Are you sure it’s the classic Read Range or the Workbook Read Range? The Workbook Read Range is known to be faster but it is less capable.

For the modern Read Range, try altering the settings in the Excel Process Scope. Specifically, set the Launch Method to Automation. This won’t load Excel add-ins but if you don’t need add-ins then it’s faster.

5

Right now it is hard to update to the latest version. Because most of client’s bot processes are running with the 21.1 version. That is what I just said. Modern excel activities should read faster than classic read range activities, not the other way around…

6

Hi, thank you for giving me the advice. However, it still takes more than 7 minutes, and doesn’t finish it when I set to Launch Method to Automation. I read the Excel add-ins part in UiPath document. Is Excel-Add in like UiPath extension? Plus I used classic read range inside Excel Application Scope when I used classic activities

7

You should try Read Range Workbook if all you need to do is load a spreadsheet - no formatting, no fancy stuff, just take this sheet and stick it in a DT.

If you don’t see Read Range Workbook, then go to the filter on your Activities tab and make sure Classic is checked. With Read Range Workbook you don’t use Excel Application Scope. You just use Read Range Workbook all by itself.

image

If you’re using Excel Application Scope and Read Range you aren’t using the more modern way. Go to settings on the Project tab and turn on modern:

image
image669×618 30.5 KB

Now you use the Use Excel File activity instead of Excel Application Scope, and there are a ton of other activities you can use inside the Use Excel File:

image
image359×687 11.3 KB

Also note that usually you want an Excel Process scope around the Use Excel File:

image
image603×658 17.6 KB

I tend to turn off “Create if not exists” and “Visible rows only”

8

Hi, thanks for the post,

I tried using Modern Read Range activity without checking Visible rows only, and Excel Process Scope Lauch Method property set to Automation. But it still takes more than 5 minutes to read… And it still doesn’t finish reading.

I am not saying there are problems about classic excel activities. I am saying there are some problems with “Excel Modern Activities”, which should perform better than classic activities. Because the name is Modern.

9

Hi @keundong26 ,

To have Modern Excel activities running Read Range faster, we recommend setting the Read formatting option to RawValue and deselecting the Visible rows only option. This makes it faster than the Classic activities.
image

However, if you’re interested in read/write in a fast way, the fastest way is using Workbook activities as it doesn’t require Excel to be installed.

Thanks,
Raluca

10

I just set my Read formatting option property to RawValue without checking Visible rows only…
It still takes more than 10 minutes with 30,000 rows… And it still doesn’t finish reading. But if I use it with Classic Excel Application Scope with Classic Excel Read Range activities it takes 6 seconds to read with 30,000 rows. AND IT IS NOT FASTER THAN CLASSIC ACTIVITIES

11

I just set my Read formatting option property to RawValue without checking Visible rows only…
It still takes more than 10 minutes with 30,000 rows… And it still doesn’t finish reading. But if I use it with Classic Excel Application Scope with Classic Excel Read Range it takes 6 seconds to read with 30,000 rows.
AND IT IS NOT FASTER THAN CLASSIC ACTIVITIES

12

Would you be able to share the project with the sample file for us to investigate this further?

Thanks,
Raluca

13

I have to ask my client if I could use the sample file.

14

Oh wait, it works as fast as classic activites when I changed Excel.Activities Package to 2.16.0 or above. Sorry. ^^; Ok But, I don’t know if it would still work, if i deployed the .nupg file to Orchestrator 2021.10.1 version.
I couldn’t use a client’s file, so I made a mock version of it.

sample_doc.xlsx (4.9 MB)