I'm trying to parse an XLSX file that was generated by another system (not IBM i) using Apache POI XSSF routines (I'm not sure which version of POI they are using).
When parsing I only get calls to my numeric cell call-back routine. All string cells are ignored.
The sheet opens fine in Excel and Google Sheets. If I save it to a new sheet I can then parse that new sheet just fine.
Any idea what this could be? Is there any additional info that would be helpful?
Thanks in advance,
Brian
XLPARSER4 not "seeing" some cells
-
- Posts: 17
- Joined: Wed Jul 28, 2021 11:04 am
- Location: Vermont, USA
- Contact:
-
- Posts: 17
- Joined: Wed Jul 28, 2021 11:04 am
- Location: Vermont, USA
- Contact:
Re: XLPARSER4 not "seeing" some cells
For completeness: It turned out the person creating the sheet had to make a change to how they were creating the sheet as they were doing something wrong.