I'm running through constraints in the format of an Excel file I have at
hand, as it's being downloaded from a carrier directly. My application
needs to read the excel file as is without preopening in Excel, then convert
it to CSV. POI fails to open it with the error:
java.io.IOException: Invalid header signature; read 4503629692403721,
expected -2226271756974174256
at
org.apache.poi.poifs.storage.HeaderBlockReader.<init>(HeaderBlockReader.java
:100)
at
org.apache.poi.poifs.filesystem.POIFSFileSystem.<init>(POIFSFileSystem.java:
84)
at com.cme.billtools.ExcelReader.main(ExcelReader.java:36)
I have noticed many threads on the net mentioning that the headers can be
set through the contenttype, but I do not have control over the carrier's
website to do that.
So my other alternative is to preprocess the Excel file in java to insert
headers, then save it, and reopen it with POI. However, I do not see any
information on doing that through the API docs. Particularly, I do not know
how to manipulate the different blocks.
If anyone has some insight on this, it would be greatly appreciated.
--Marwan
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
