Select until the end of a column starting from a specific cell

Help
1

Hi, team!
How can I select until the end of a column (end of data) starting from a specific cell?
A wanna start from cell A3, and go until the end of the column that contains data.

Thanks!

1 Like
2

In read excel activity, select range as "A3"

2 Likes
3

Hi @Giulia_G
use select range as "A3:A +DtTable.rows.count.ToString

Thanks
Ashwin S

4

@kuppu_samy, I’ve already tried, is giving me only cells A1 til A3… In my mind this should work too, but isn’t

1 Like
5

Hi @Giulia_G,
What do you mean end of data?
If the Excel sheet has 10 data, it will give 10 rows.

If you want to read data in between range. Give the cell name or cell range like A2 and A2:C5 respectively

2 Likes
6

@Giulia_G

In Read Range activity, mention Range as “A3” and it will start reading data from A3 cell to end of the data.

5 Likes
7

I’ve made some changes, and it works! Thanks a lot!!!

1 Like
8

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