How to get cell position of an excel

studio

#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