Well, a RecordFormatException indicates - and I am simplifying a bit here - that there is something in the structuire of the file that HSSF either cannot understand or is not expecting.
Could you please; Create a file using jXLS. Just to make sure that the file is causing problems, try to open it now using HSSF. If you see the RecordFormatException then open the file using Excel and re-save it. Try to use HSSF to open this version of the file. Hopefully, that will have cleared the problem and will suggest that jXLS is creating a file that may contain a fault but it is one that Excel corrects and the next thing you need to do is to try and isolate the cause. My suggestion would be to start with an empty - or at least very simple - workbook generated using jXLS then try to open that using HSSF. If you can successfully proces the simple workbook using HSSF keep adding features iteratively until you isolate what is causing the problem. --- On Tue, 11/25/08, Sungwon Jung <[EMAIL PROTECTED]> wrote: From: Sungwon Jung <[EMAIL PROTECTED]> Subject: jXLS & RecordFormatException To: [email protected] Date: Tuesday, November 25, 2008, 12:49 AM Hello. POI is great open source program! I'm using jXLS v.0.9.6 and POI 3.0.2-FINAL. problem is this. jXLS makes excel file and then POI cannot read that file. exception occured. "org.apache.poi.hssf.record.RecordFormatException: Unable to construct record instance" Because of jXLS cannot supported POI lastest version, I cannot upgrade POI lastest version. I've 3 question. 1) what's mean of RecordFormatException? 2) why RecordFormatException occured? 3) how can I solve this problem? (jXLS 0.9.6 + POI 3.0.2-FINAL) thank you. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
