Free Support Forum -


I try to use Cells.Rows to loop on all Rows but it’s not working.
Cells.Rows doesn’t contains all Rows. I don’t understand what sort of rows are in. Can you explain me ?

For exemple :
Dim oWorkbook As Aspose.Cells.Workbook = New Aspose.Cells.Workbook
Dim oWorkSheet As Aspose.Cells.Worksheet = oWorkbook.Worksheets(0)

If you test oWorkSheet.Cells.Columns.Count it’s : 0
If you test oWorkSheet.Cells.Rows.Count it’s : 0

After oWorkSheet.Cells(0, 0).PutValue(“test”)

it’s always 0

Rows collection only contains rows with explicit height and format settings. It's independent of data in the worksheet.

You can try to use Cells.MaxDataRow property.