I want to control a specific excel cell

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

Hi @hj2

Yes you can read the particular column if know the which column. you can mention the specific column in read range ex

image

1 Like

@prakaz25 Hello :slight_smile:
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

2 Likes

Use Read Column Activity. The output of this activity will be IEnumerable(Object), which you can loop though directly or convert to an array.
Capture

2 Likes

@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

1 Like