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

[Yoichi]

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)

Bug in modern excel activity (?)

Hi @wija , That’s correct, there is a difference between Classic and Modern Excel and currently, there are no exceptions thrown when the Sheet doesn’t exist. We are looking into throwing an error in these cases so I’ll add this to our insights to the functionality. Regarding the Read Range slowness, we recommend setting the Read formatting option to RawValue and deselecting the Visible rows only option which will improve the performance. More details in the documentation - Activities - Read Ra…

Regards,