Page 1 of 1

XLPARSER4 not "seeing" some cells

Posted: Fri Jan 28, 2022 1:16 pm
by brianjgarland
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

Re: XLPARSER4 not "seeing" some cells

Posted: Thu Mar 03, 2022 6:10 pm
by brianjgarland
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.