Hi, I use read range activity for get data start from A6. But A6 column name and G6 column name are same so that I get error. I want to get data A6 and F*. Data is very big, The number of rows varies between 5 thousand and 10 thousand. What should I write in the cell section?
Check on this post, it should work.
Hey
You can use this activity to read large excel sheets
In the read range propertie you can use âA6:Fâ
Regards
You can try like this
As you did use read range from A6 and disable add headers in the properties of that first read range and store them in a datatable called DT1
- Second Read Range give the range like âA6:Fâ+(Dt1.Rows.Count+1).Tostring and save them in another DT called Main_DT
Regards
Sudharsan
1 Like
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.