Why is read range activity taking too long on StudioX?

Hi,
I’ve been using Studio for years and I’m coaching citizen developers on StudioX. The same file is taking way too long to be read when Read Range activity is used on StudioX, it goes up to 10 mins for files that has few thousand rows. Why is that so? Studio will take barely take few seconds even for 100k rows.

@niro

Check the filesize of the Workbook being read, if it’s kinda huge there may be unused/empty cells that register as used. Deleting those rows should solve the issue.

Hope this helps!

Hi,

If you use older version of Excel.Activities package, can you try to update it to 2.20.1 or above?

And the above document also says as the following.

To increase performance further, we recommend setting the Read formatting option to RawValue and deselecting the Visible rows only option.

Regards,

1 Like

this seems to work. thank you!

1 Like

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