I want to read data corresponding to column G in excel.
Is there a way?
If there is no way, I want to find a cell in G1 and change the data. What should I do?
Hi @hj2
Yes you can read the particular column if know the which column. you can mention the specific column in read range ex
@prakaz25 Hello
When used in that way, the H, I, and J columns behind the column G follow.
I only want to get column G.
Hi @hj2
There is another way we can get specific column. First read the Excel you will get Data-table as result.
From the Data-table you can get which column you want
dt_New=dt_Original.DefaultView.toTable(false,”Column1″,”Column2″,…)
Note:
Simply replace the “Column1″,”Column2” and so on with your required Column
Use Read Column Activity. The output of this activity will be IEnumerable(Object), which you can loop though directly or convert to an array.
@hj2, If you specify only one cell in Read Range activity then it will read all data starting that cell. As work around, you can specify range like “G1:G1000” where 1000 is random big number you can think of.
Then remove blank rows using Filter Data Table activity.
Cheers