To answer your questions in the wrong order, when you open a file with Excel and then re-save it, Excel will correct any errors that existed in the file and make sure that it conforms to the file specification. As a result, when you then try to open the file with POI, the error will have been removed - by Excel during the save operation - and you will not see the error. So, it is not so much a case of where the file is stored but that Excel has repaired it for you.
Now, the reason Nick asked how the original file was prepared is that there are quite a few applications that generate Excel workbook files that include errors. Excel is quite happy to ignore these errors and clean the file up before displaying it to you but POI is more in-tolerant of them. So, you have a few options; to make sure that your source files are correctly generated in the first place, to use Excel to repair the damage or to log this as a bug. For the developers to look into the problem, they will require a test file which you will have to upload for them if you raise this as a bug. Of course, make sure that any sensitive information is obfuscated and obtain the agreement of your managers before doing this. -- View this message in context: http://apache-poi.1045710.n5.nabble.com/unable-to-create-record-instance-Not-enough-data-0-to-read-requested-6-bytes-tp5709794p5709812.html Sent from the POI - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
