Read Range activity is taking near to 1 minute for reading only 5 rows

Help StudioX
,
1

I am checking StudioX for one of our citizen developers and it is found that the read range activity is taking way more time compared to Studio. Sometimes - the wait is endless

I tried with a simple file which contains only 2 columns and 5 rows - It took around 1 minute to complete the action

Any known issue / solution for this issue?

2

HI @sharazkm32

apart from this delete all the temp files from that machine. You can find these files by using Run type %temp% & delete these files.

Hope this will help. :slight_smile:

1 Like
3

Hi @sharazkm32

Try using the Read range workbook activity instead of using the Excel activities.

Hope you understand!!

4

Hi @mkankatala

I am using StudioX where I believe Read Range Workbook activity is not available. Let me know if I am wrong

5

Workbook activities are available in Studio X but you have to enable the developer option.

Follow below steps to enable the developer option-
→ Go to Activities panel
→ Click on Filter and Check the developer.

Hope it helps!!

1 Like
6

We dont want Citizen Developers to use Developer Activities. Also the solution suggested in the above thread is also not working as expected. It is still taking time even after modifying the configuration value as Raw Value for Read Formatting

7

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
8

I have provided the configuration in Read Range as well and it is working fine as expected. Thank You @AJ_Ask and @Yoichi for sharing the solution

Marking Solution for the one which I have received first

Appreciate all your support

9

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