Hello,
I have an excel file that contains one column, and many rows , i just need to read the value of the last cell.
Any help please!
Two options, try both
- using app scope, read the excel file, goto the last row of the DT
dt(dt.Rows.Count-1)(0).toString //assume 0 is the column index
- Open the excel, send key - Ctrl+End, read the content of the cell
1 Like
i can reach the last row in the excel file by using dt.rows.count
but i couldn’t extract the value of that cell
dt(dt.rows.count-1)(columnnIndex)
1 Like