Need assistance while reading excel count basis on that read that row count in another excel

Let say I have 2 excel spreadsheet from 1st spreadsheet I am taking DT1.rows.count.tostring
& in Second excel I need to read only M “column” + DT1.rows.count.tostring ( Total no. of rows in first excel)

but its reading whole column M which is not my requirement.

Any help would be appreciated here !!

Thanks in Adavnce…


Then in second excel use read cell activity with "M" + dt.Rowcount.ToString as the cell value

If modern read cell then Excel.Sheet("Sheetname").Cell("M" + dt.Rowcount.ToString)