Reading the value of the last cell in an excel file

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

  1. 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

  1. 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