B4J Question ColumnCount in jPOI

Douwe Siegersma

Member
Licensed User
Longtime User
I'm replacing the jExel library with the jPOI library for reading Excel files.
The only problem I've encountered is the missing ColumnCount property of a worksheet.
Is there an easy way to determine the number of columns in a worksheet?
Regards,

Douwe
 

DonManfred

Expert
Licensed User
Longtime User
B4X:
For Each row As PoiRow In Sheet.Rows
For Each cell As PoiCell In row.Cells
  Log(cell.Value)
Next
Next

row.Cells.size (or .length) is probably what you are searching?
 
Upvote 0
Top