We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Count the number of rows existed in a Excel Sheep

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

Hi<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

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

Best regards.

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.