Read range from Excel with dynamic row end

[Katja]

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

[Palaniyappan (Palaniyappan P)]

Hi
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

[Katja]

Wow, that was easy

Thx a lot @Palaniyappan