代码如下:
int MaxRow = ((Range)(workSheet.Cells[workSheet.Rows.Count ,CellIndex.SheetNameColumnIndex]))
.End[Microsoft.Office.Interop.Excel.XlDirection.xlUp].Row;
workSheet.Rows.Count为Excel每个sheet的最大行数,CellIndex为要找的列,然后用Range.End找到最后一行有内容的行号。