ClassCastException on Excel-Load with Image in sheet POI 2.5-final

[Ralf Fischer]

Hello List,

few weeks ago I started using POI in a report tool to avoid Excel-Save as CSV.
The Excel File contains 4 Sheets, 1 cover, 1 index and 2 lists important for 
me. In fact I need just one column. 

Well, on loading this File I get a ClassCastException when I Construct a 
HSSFWorkbook, handing the corresponding POIFSFileSystem on the Excel file:

<exception>
java.lang.ClassCastException
  at java.util.TreeMap.compare(TreeMap.java:1081)
  at java.util.TreeMap.put(TreeMap.java:459)
  at 
org.apache.poi.hssf.record.aggregates.ValueRecordsAggregate.insertCell(ValueRecordsAggregate.java:65)
  at 
org.apache.poi.hssf.record.aggregates.ValueRecordsAggregate.construct(ValueRecordsAggregate.java:130)
  at org.apache.poi.hssf.model.Sheet.createSheet(Sheet.java:192)
  at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:174)
  at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:132)
  [snip]
</exception>

As an of course not nice workaround I removed this first sheet named Cover, what
actually not solved the problem, the error didn't occur any more. 

The file in question is available on the internet under this unfortunately long URL:
http://www3.deutsche-boerse.com/INTERNET/IP/ip_stats.nsf/(KIR+Xetra+Stars+taeglich)/2F8D6B9F0D183DA1C1256EE40020E5B4/$FILE/XetraStars.xls?OpenElement
 
 - yeah, Notes Domino Server is a nice thing ;-)

Here is the code I use for this. Maybe someone can tell me where this comes from :-)

<code>
private static Set loadExcelSegmentDefinition( File _file , 
                                String _sheetName ) throws Exception {
    log.info( "Loading sheet \"" + _sheetName + "\" from file \"" +
              _file.toString() + "\"..." );
    HashSet result = new HashSet();
    if( _file == null ) return result;
    HSSFWorkbook wb = null;
    try {
        POIFSFileSystem fs = 
        new POIFSFileSystem( new FileInputStream( _file ) );
        wb = new HSSFWorkbook( fs );
    } catch( IOException e ) {
        log.error( "Could not load File \"" + _file.toString() + "\"" );
        return null;
    }
    if( wb != null ) {
        HSSFSheet sheet = wb.getSheet( _sheetName );
        if( sheet == null ) {
            log.error( "No sheet with name \"" + _sheetName + 
                       "\" in file \"" + _file.toString() + 
                       "\"" );
            return null;
        }
        final int row_start = 12;
        final int row_end = sheet.getLastRowNum();
        final short wkn_cell = 2;
        for( int i = row_start ; i <= row_end ; i++ ) {
            HSSFRow row = sheet.getRow( i );
            HSSFCell cell = row.getCell( wkn_cell );
            if( cell != null ) {
                String cellValue = cell.getStringCellValue();
                if( cellValue != null ) {
                    result.add( cellValue );
                }
            }
        }
        }
    if( result.size() > 0 ) {
        log.info( "Loaded " + result.size() +" Figures." );
    } else throw new Exception( "No Figures found in File \"" +
                                _file.toString() + "\", sheet \"" + 
                                _sheetName + "\"!" );
    return result;
}
</code>

For this all I use JDK1.4.1_01 on WindowsNT 4.0 and 
poi-2.4-final-20040302.jar (contrib & scratchpad same version if important).

Thanks, 
   Ralf



-- 
Ralf Fischer


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]