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