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