Why is READ RANGE ACTIVITY of MORDER so very slow in reading data?

Help Activities
, ,
1

image

When trying to read 7000 rows of data in 5 columns in a sheet in Excel,

  1. Using READ RANGE ACTIVITY of MORDER, it takes 80 seconds to read.
  2. Using READ RANGE ACITIVITY of CLASSIC, it takes 1 second to read.

Why is READ RANGE ACTIVITY of MORDER so very slow in reading data?

Even if I change the options in Use Excel File and try several times, there is only a slight difference in time, but the default is very long.

2

Hi @sumouse

Are you using any excel activities in the use excel file or else have you been using only the read range excel activity?

Regards

3

Only Using Activity

Excel Process Scope > Use Excel File > Read Range

4

Hi @sumouse

Then please instead of excel activities try using the read range workbook activity.

Regards

5

Hi,

It’s known ReadRangeX is very slow in some environment / worksheet.
The following post may help you regarding settings for mitigation this problem.
(However, it may not solve it completely)

Regards,