You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by Sungwon Jung <th...@gmail.com> on 2008/11/25 09:49:42 UTC

jXLS & RecordFormatException

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: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org


Re: jXLS & RecordFormatException

Posted by Anthony Andrews <py...@yahoo.com>.
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 <th...@gmail.com> wrote:
From: Sungwon Jung <th...@gmail.com>
Subject: jXLS & RecordFormatException
To: user@poi.apache.org
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: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org