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
Hi
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.