Bug? aPOI crashes trying to read xls file. Works perfect with xlsx files

[Robert Valentino]

I tried this library aPOI and I can read a xlsx file but get a crash same file saved as (using Windows Microsoft Excel to do save as) xls

Has anyone tried the aPOI library with xls files of just assumed it works.

Attaching the to excel files.

If I determine the file is xls and use the Excel library and ReadableWorkbook to read it works fine.

aPOI library says it will read xls or xlsx files but doesn't seem to like xls files?

WOULD post my code. But it has the changes I made to phone library to support content chooser allowing multiple MIMEs

Maybe someone could try aPOI library with both these files and verify what I am saying is true, would greatly appreciate it

 

[Robert Valentino]

Attached a working example that tries to read a xls file and crashes.

Works fine if I use a xlsx file (but my users would like me to support either - NOTE if I use the Excel library instead of aPOI it reads xls file fine)