How to read range a column with a specific row start and a dynamic row end?

Help Activities
, ,
1

Greetings, I’m trying to get all the rows that I could from a column but without a specific row end.

eg.
First line of data starts on A4 and would have random amounts of data it.

2

had you tried read range with offset range A4

3

Hi @wdescalsota

You can pass the dynamic number in Read Range activity:

image

In case you do not know what will be the last row, you can at first read whole range and save it to temporary data table, only to get the number of rows and then filter the data table appropriately (leave only desired columns) or read range with already obtained number of rows (adjusted to Excel indexes)