How to get cell position of an excel

Help
1

Hi, if I have an excel sheet like below and have already read range and saved as datatable.
May I ask how can i get the cell position of that empty cell in Column “Address”?

Name Age Address
Ann 12 (empty)
Cynthia 15 USA

I want it in the format of “C3” because the plan is to use a write cell later on to fill in that cell.

2

is the empty cell always going to be on the C column?

3

@Tiberiu_Niculescu It will always be in Column “Address” . I’m working on someone’s request, IF it will always be in column C, how will you approach it?

4

considering that only one cell is going to be empty, you could go through all of the datatable contents using a for each row and if row(2) is nothing then assign to an int variable, myInt = datatable.rows.indexof(row) and that will be the index of the row which has an empty cell on the column C

if there will be multiple empty cells, you should consider using a list

5

Hi,
I have similar issue.
i want to get transaction item from Queue item and put it back into excel file as a final result. but the result is always get the last queue items and write to excel.
i use write cell activity to write the data, but i don’t know how to set the range to be match with the cell position of the Items. Anyone can help me? Thanks
Rgrds,
Ann