>I'm using the latest API If you are using "POI 2.5 FINAL", I found that it has a serious major error when the .xls file contains any graphics.
Refer to http://issues.apache.org/bugzilla/show_bug.cgi?id=27933 Maybe you could add to it your findings too. Thanks! Regards, Daniel -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, 05 April, 2004 1:56 PM To: POI User List Subject: Corruption problem with Excel Hi all I've just started experimenting with POI. I encountered a problem which I didn't manage to find any help on it. I started with a simple code like this which simply reads an excel file and writes it back into a new file without modifying it (I think). try { iStream = new FileInputStream("Errors Analysis.xls"); fs = new POIFSFileSystem(iStream); wb = new HSSFWorkbook(fs); oStream = new FileOutputStream("wb2.xls"); wb.write(oStream); } catch (Exception e) { e.printStackTrace(); System.exit(0); } finally { if (iStream != null) { try { iStream.close(); } catch (Exception e) { iStream = null; } } if (oStream != null) { try { oStream.close(); } catch (Exception e) { oStream = null; } } } With a simple excel file this works fine. But if in the excel file I have a graph, or an image, or a pivot table, then the file gets corrupted and looses all formatting. I read that POI is not able to format such objects but it does support them. Is this something wrong with POI or am I doing something wrong? I'm using the latest API, Windows XP and JDK 1.3.1. I tried working on a 2002 and 2003 format excel file. Thanks Edward _________________________________________________________________ Send your loved ones Easter Eggs and Figolli this Easter. Shop online at http://shop.di-ve.com --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
