How to read range an excel file, without including the empty rows before reading it

Help Studio
1

Hi! I’m currently learning about excel manipulations in excel and sometimes, I tend to encounter this problem. Right now, I have an excel file which contains around 250 rows, read ranging it to “A1:B251” works fast and easy. But now, I’m trying to read it like “A:B” and it takes a very long time to read(5 mins as of now). I know how to delete the empty rows after read ranging it, I’m hoping that it would just read the table, and it would stop reading after that. Is there a work around here?

2

@RGT

Welcome to our UiPath community.

Try to specify range as “A1”.

1 Like
3

Hi reading 250 rows should not be that long ,
try specify the range to empty like this range → “”
this will read everything on the sheet , and you can toggle the option of include header/not include header on properties panel

1 Like
4

Thanks. It Works fast right now. Do you know the reason why “A:B” does not work?

1 Like
5

Thanks. this works just fine too.

6

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