Read range from Excel with dynamic row end

Hey there,

I want to copy a range from Excel where I know the starting point (cell A5) but I don’t know the end row because this might change everytime the data is downloaded from the system. What do I write into the “Range” properties?

I tried - as suggested in another thread here - “A5:AA”+lastRowIndex.toString. For this I get the error that lastRowIndex is not declared.

Can anybody help?
Thx in advance

1 Like

Welcome to uipath community
In the READ RANGE activity mention the range as “A5” so that it will start from A5 and reads till end
If the header starts from A5 enable the ADD HEADERS Property in the property panel of read range activity

Cheers @Katja


Wow, that was easy :slight_smile:

Thx a lot @Palaniyappan

1 Like

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