'get the number of rows
x=sheet.LastRowNumber
Dim pc As PoiCell
XLList.initialize
'get only data rows, avoid header row
For i=1 To x
For j = 0 To 7 'eight columns
If sheet.GetRow(i).GetCell(j).IsInitialized=True Then
pc=(sheet.GetRow(i).GetCell(j))
'convert all data to string
pc.CellType=1
XLList.add(pc)
Else
XLList.Add("")
End If
Next
Next
Thanks for your reply.
I want to be sure I import all the cells even in if they are null from the Excel spreadsheet.
This data will be added to a SQLLite table so an empty cell is still "data".
Thanks
Graham