We have roughly 100,000 workbooks in HSSF format, we are currently
seeing a large number of files error out from POI during the initial
loading of the workbook. Many of these files work just fine in Excel and
we've already ignored files that wouldn't open in Excel when we came
across them. I was wondering if any of these errors could be a POI
problem and not exactly the workbook.
If any of these can be easily fixed or worked around please let me
know.... Already tried saving in Excel but its complicated by the fact
that we cant save every workbook using that method as we have over 8,000
not currently loading. Here is a list of things we've found. Due to
these workbooks containing private information I am unable to send them
out. Worst case I might be able to clear out a workbook, get approval,
and send one if I'm lucky. I would assume for now that I cant send them
out. Thanks for any help.
Unable to open file!
Cannot remove block[ 30408811 ]; out of range[ 0 - 1505
]
Unable to open file!
Cannot remove block[ 1274923274 ]; out of range[ 0 -
3545 ]
Unable to open file!
Cannot remove block[ 1274923274 ]; out of range[ 0 -
4770 ]
Unable to open file!
Cannot remove block[ -1450656249 ]; out of range[ 0 -
2694 ]
Unable to open file!
Unable to read entire header; 0 bytes read; expected 512
bytes
(roughly 80% of my 8,000 problem files have this exact error....
most important issue to address for us)
Unable to process excel record that is larger than 8224 bytes
Unable to construct record instance
Unable to process excel record that is larger than 8224 bytes
The content of an excel record cannot exceed 8224 bytes
Cheers,
Zach Davis
Associate IT Programmer Analyst
R.L. Polk Southfield Office
*****************************************************************
This message has originated from R. L. Polk & Co.,
26955 Northwestern Highway, Southfield, MI 48033.
R. L. Polk & Co. sends various types of email
communications. If this email message concerns the
potential licensing of a Polk product or service, and
you do not wish to receive further emails regarding Polk
products, forward this email to [email protected]
with the word "remove" in the subject line.
The email and any files transmitted with it are confidential
and intended solely for the individual or entity to whom they
are addressed.
If you have received this email in error, please delete this
message and notify the Polk System Administrator at
[email protected].
*****************************************************************
