poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Daniel Joshua" <daniel.jos...@gridnode.com>
Subject RE: Corruption problem with Excel
Date Tue, 06 Apr 2004 02:02:33 GMT
>Keep adding sample sheets onto the bug.

Nice idea...

By the way, just out of curiousity, how much do/will you charge for making
those changes?


Regards,
Daniel


-----Original Message-----
From: Andrew C. Oliver [mailto:acoliver@apache.org]
Sent: Tuesday, 06 April, 2004 1:56 AM
To: POI Users List
Subject: Re: Corruption problem with Excel


Yes, for reading/modifying spreadsheets with graphics you need to use 2.0 or
be prepared to file bug reports and help out with 2.5.  2.0 ignores
graphics.  2.5 attempts to read/interpret them.  However, the graphics API
added was MASSIVE.  Our client was primarily interested in *writing*
spreadsheets and thus funded primarily that work.  I'm working on a quote
for another client who wants more of a read centric system and that may
stabilize it, but its going to take a lot of use cases from folks to get it
perfect.  Keep adding sample sheets onto the bug.
--
Andrew C. Oliver
http://www.superlinksoftware.com/poi.jsp
Custom enhancements and Commercial Implementation for Jakarta POI

http://jakarta.apache.org/poi
For Java and Excel, Got POI?

The views expressed in this email are those of the author and are almost
definitely not shared by the Apache Software Foundation, its board or its
general membership.  In fact they probably most definitively disagree with
everything espoused in the above email.

> From: "Daniel Joshua" <daniel.joshua@gridnode.com>
> Reply-To: "POI Users List" <poi-user@jakarta.apache.org>
> Date: Mon, 5 Apr 2004 15:06:49 +0800
> To: "'POI Users List'" <poi-user@jakarta.apache.org>
> Subject: RE: Corruption problem with Excel
>
>> 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: exuereb@di-ve.com [mailto:exuereb@di-ve.com]
> 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


---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org


Mime
View raw message