Can't Read More Than 1000 Rows Using Read Range Activities

Help Activities
, ,
1

Hello guys,

I have a problem about Read Range Activities in my Studio. I have data in excel is more than 1000 rows (more than 1000 data), but the output of my Read Range Activities is stop in the rows number 56 (data number is 51).

Output Value & Read Range Activities Properties:

image
image963×548 27.1 KB

I hope for your help guys to resolve my problem. Thanks in advanced :pray:
Regards,
Brian Henokh

2

Hello @henokhbrian
in Local panel it will only show limited data.
try to print row number instead like mydt.rows.count this should give you the actual row count.

1 Like
3

Hi @henokhbrian
Is it throwing a error while reading excel file,

if yes try to consider the excel as DataBase and then read it

for more info check this link :
How To Use Excel As Database – In UiPath – ExcelCult

1 Like
4

Oh i see, that’s work. Thank you very much.
But why in the local panel didn’t showed a full data? How many data for the limit to be showed?

5

Thank you for your suggestion. The read excel activities is working normally, but only the data of my activities is not showed 100% in my local panel.
Maybe sometime i will try your suggestion. :pray:

6

I guess there is data size limit, not sure how much that limit is. I too sometime struggle with this broken feature.

7

I have created a new post for this feature to get fixed. Please upvote it.

8

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