hi,
i have seen this note on the bugzilla list.:
***********************************************************************************************************
Summary: reading files generated by SpreadCE 1.18 causes
Exception.
Product: POI
Version: unspecified
Platform: PC
OS/Version: Windows NT/2K
Status: NEW
Severity: Normal
Priority: Other
Component: HSSF
AssignedTo: [email protected]
ReportedBy: [EMAIL PROTECTED]
When I try to read excel files generated by SpreadCE 1.18 running under
WindowsCE 2002 and WindowsCE 2003 I find two troubles:
1) org.apache.poi.hssf.record.agregate.ValueRecordsAgregate.construct(int,List)
fail when org.apache.poi.hssf.record.LabelRecord are included in the agregate
because the java.util.TreeMap need that the keys implement the Comparable
interface and LabelRecord doesn't do.
2) If I try to resolve the previous trouble by implementing Comparable interface
in LabelRecord as it was implemented in other Record extended classes
(LabelSSTRecord by example). When I do that,
org.apache.poi.hssf.model.Sheet.convertLabelRecords(Workbook) can't replace
LabelRecords included inside the ValueRecordsAgregate. This causes Exception in
the org.apache.poi.hssf.usermodel.HSSFCell constructor because is unable to
recognize the LabelRecord Type.
I resolve this by inserting code for convert from LabelRecord to LabelSSTRecord
prior to Sheet generation in org.apache.poi.hssf.usermodel.HSSFWorkbook
constructor instead of calling Sheet.convertLabelRecords() after Sheet
generation.
***********************************************************************************************************
i need the same functionality. But i could not understand what is told in the
last pharagraph(constructor of hssfworkbook). Can somebody tell?
Also i did not understand how to build a new jar from the source files. On the
jakarta page it does not tell the names of the ant script(s) and where they are
located?
thanks in advance.
best regards..
---------------------------------------------------------------------
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/
