Cells.Rows.Count of worksheet problem

Aspose.Cells Product Family
1

Dear,

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

Mamun

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