B4J Question jPOI: rows.cells.size -> only filled cells counted?

[KMatle]

Reading an Excel i mentioned that rows.cells.size only counts filled cells. Inside my Excel sheet some columns are empty, so I get different results for each row.

Is that correct or am doing it wrong?

What I try to do is match the row values to the first row (headers) which goes wrong here.

For x=0 To sheet.Rows.Size-1
      row=sheet.Rows.Get(x)
      For i = 0 To row.Cells.Size-1
           Log(x & ":" & row.Cells.size)
      Next
Next

 

[KMatle]

Yes, it does. See here: https://www.b4x.com/android/forum/threads/detect-empty-poi-cells.63188/