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