XLPARSER4 not "seeing" some cells

Scott Klement's open source interface to the POI HSSF/XSSF Spreadsheet Project for RPG Programmers. http://www.scottklement.com/poi/
Post Reply
brianjgarland
Posts: 17
Joined: Wed Jul 28, 2021 11:04 am
Location: Vermont, USA
Contact:

XLPARSER4 not "seeing" some cells

Post 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
brianjgarland
Posts: 17
Joined: Wed Jul 28, 2021 11:04 am
Location: Vermont, USA
Contact:

Re: XLPARSER4 not "seeing" some cells

Post 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.
Post Reply