Count the number of rows existed in a Excel Sheep

Aspose.Cells Product Family
1

Hi All,

We have one excel sheet,In that client entered some N number of rows.

By using Aspose how to the number of rows existed in a excel sheet

Thanks

2

Hi

Thank you for your interest in Aspose products. I move this thread into the Aspose.Cells forum. They will answer you shortly.

Best regards.

3

Hi,

Please use Cells.MaxDataRow and Cells.MaxDataColumn properties to get the last row/column index which contains data in a sheet.

e.g..,

Workbook workbook = new Workbook();
workbook.Open("f:\\test\\MyWorkbook.xls");
Cells cells = workbook.Worksheets[0].Cells;
int lastrowindex = cells.MaxDataRow;

Thank you.