How to count any range in an excel sheet

how to count the range in Excel from A to G if the starting cell is A4, and the range is changeable. How to register Read Range in the activity so that it reads the entire range from A4 to G…, regardless of the number of lines.
It is necessary to read the range without headers


We can just mention as “A4”. So that READ RANGE ACTIVITY will read from A4 to the entire sheet

Regarding headers there is a property called ADD HEADERS which if disabled read range activity will create its own column name as Column-1, Column-2,…Column-N exclusive of the data

Hope this clarifies

Cheers @yulya

1 Like

What Plalniyappan suggested is a good option,
I had another idea read range “A:G” , after reading remove first 4 rows from the data table

1 Like

Thank you very much! it works

1 Like

Thank you!

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