How to read a range with unknown row numbers

I’m really new to UiPath and I need to copy some data from an excel sheet. The columns are fixed from A-F but the number of rows will vary. How do I put this data into a data table? I tried read range with just the columns A:F, but i think that copied all the rows those columns had, not the data specifically.
Any tips / solutions?

@zham667 first read the excel normally using read range activity (for example dt will be the output).
Then again read the excel using read range activity with range as
“A1:F”+(dt.Rows.Count-1).ToString
Above range will give you required output

2 Likes