Read range so slow

Help Activities
1

This image shows the "Read Range" activity configuration in UiPath with options to specify the range, indicate that the data has headers, select only visible rows, and specify where to save the output. (Captioned by AI)
This image shows the "Read Range" activity configuration in UiPath with options to specify the range, indicate that the data has headers, select only visible rows, and specify where to save the output. (Captioned by AI)687×274 9.58 KB

Excuse me, when I read an Excel file with 20000+ lines, the speed is very slow, and there is no response for 2-3 minutes. Is there something that hasn’t been set up, right?

2

@11197256 , compare the speed with “Read Range Workbook” activity outside the Excel scope.

3

Hi,

For now, can you try to set RawValue explicitly at ReadFormatting in Property panel and turn off Visible Row only, as the following image?

image
image1298×779 35.5 KB

Regards,

4

thank you！thank you! This setting will be done quickly！！

5

Read Range Workbook This is much faster!