Free Support Forum - aspose.com

Cells.Rows.Count of worksheet problem

Dear,

worksheet.Cells.Rows.Count doesnt able to count blank rows. how can i do this?

Mamun

Hi Manun,

Thanks for considering Aspose.

Well, I think you may use Cells.MaxDataRow or Cells.MaxRow properties to get the farthest row index to obtain the numbers of rows set. For example if the farthest row index is 29, it mean your data is splitted may split on 30 rows.

E.g.,

.
.
int mrow = cells.MaxDataRow;
int numrows = mrow+1;

Thank you.