XLPARSER4 not "seeing" some cells
Posted: Fri Jan 28, 2022 1:16 pm
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
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