Hi Amol
I tried the alpha, but alas, same result:
java.lang.IllegalArgumentException: Start and end index not in range.
at
org.apache.poi.hssf.usermodel.HSSFRichTextString.applyFont(HSSFRichTextString.java:61)
at
org.apache.poi.hssf.record.TextObjectRecord.processFontRuns(TextObjectRecord.java:148)
at
org.apache.poi.hssf.record.TextObjectRecord.processContinueRecord(TextObjectRecord.java:131)
at
org.apache.poi.hssf.record.RecordFactory.createRecords(RecordFactory.java:199)
at
org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:183)
at
org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:152)
at org.apache.poi.hssf.dev.HSSF.<init>(HSSF.java:67)
at
net.instadia.datamining.ResultFormatterXLS.main(ResultFormatterXLS.java:546)
And my code is REALLY simple:
public static void main(String args[]) {
try {
String a[]=new String[2];
a[0]="/tmp/Custom Report example.xls";
a[1]="/tmp/res2.xls";
HSSF.main(a);
} catch (IllegalArgumentException e) {
e.printStackTrace();
}
}
This file is a valid Excel file, that opens just fine in oocalc,
gnumeric and excel 2003.
/Philip
Amol Deshmukh wrote:
Philip,
Can you try building the latest version from the source?
As I understand, the RichTextString functionality has
undergone some major changes in the latest source.
Else you could try the 3.0alpha build in the path on a mirror
site. The relative path on a mirror site is:
/apache/jakarta/poi/dev/bin/poi-bin-3.0-alpha1-20050704.tar.gz
HTH,
~ amol
-----Original Message-----
From: Philip Mailinglist [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 30, 2005 9:39 AM
To: [email protected]
Subject: Compatibility issue reading excel file?
Hi,
I've been using poi for writing hssf with great success. Now I'm
starting to read and modify spreadsheets and I get into trouble. On
debian package POI version 1.1 it complains but works, but
entire rows
disappear from the dataset.
Then I downloaded 2.51-FINAL from the web site but it refuses
entirely
to load my document.
java.lang.IllegalArgumentException: Start and end index not in range.
at
org.apache.poi.hssf.usermodel.HSSFRichTextString.applyFont(HSS
FRichTextString.java:61)
at
org.apache.poi.hssf.record.TextObjectRecord.processFontRuns(Te
xtObjectRecord.java:148)
at
org.apache.poi.hssf.record.TextObjectRecord.processContinueRec
ord(TextObjectRecord.java:131)
at
org.apache.poi.hssf.record.RecordFactory.createRecords(RecordF
actory.java:188)
at
org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook
.java:163)
at
org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook
.java:130)
at org.apache.poi.hssf.dev.HSSF.<init>(HSSF.java:67)
at
net.instadia.datamining.ResultFormatterXLS.main(ResultFormatte
rXLS.java:546)
I do not know what to do next. Any suggestions?
/Philip
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
