You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by Stefan Shoeman <st...@googlemail.com> on 2007/03/07 14:47:46 UTC

more than one Excel-sheet with charts

Hello *,

is it possible (using HSSF 2.5), that I write some values into a
predefined Excel-template, which consists of two sheets: one with the
values, the second with a chart (pointing to the data of sheet #1)?

Imho the old 1.X HSSF POI isn't able to do that.

--
Regards,

Stefan Shoeman

---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/


Re: more than one Excel-sheet with charts

Posted by Stefan Shoeman <st...@googlemail.com>.
Thanks for sharing your experience. Now I will try it with an
up-to-date version, too.

2007/3/7, Theo Antonopoulos <th...@empowered-systems.com>:
> Stefan,
>
> It is possible. I have done it by creating the chart in an excel
> template and then I load that template using POI and just update the
> data number in the cells.
>
> We are using POI3 alpha 1.
>
> Theo
>
> -----Original Message-----
> From: Stefan Shoeman [mailto:stefan.shoeman@googlemail.com]
> Sent: 07 March 2007 13:48
> To: poi-user@jakarta.apache.org
> Subject: more than one Excel-sheet with charts
>
> Hello *,
>
> is it possible (using HSSF 2.5), that I write some values into a
> predefined Excel-template, which consists of two sheets: one with the
> values, the second with a chart (pointing to the data of sheet #1)?
>
> Imho the old 1.X HSSF POI isn't able to do that.
>
> --
> Regards,
>
> Stefan Shoeman
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
> The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/
>
>
>
>
>
>
> This message has been scanned for viruses by BlackSpider MailControl - www.blackspider.com
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
> The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/
>
>

---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/


RE: more than one Excel-sheet with charts

Posted by Theo Antonopoulos <th...@empowered-systems.com>.
Stefan,

It is possible. I have done it by creating the chart in an excel
template and then I load that template using POI and just update the
data number in the cells. 

We are using POI3 alpha 1.

Theo

-----Original Message-----
From: Stefan Shoeman [mailto:stefan.shoeman@googlemail.com] 
Sent: 07 March 2007 13:48
To: poi-user@jakarta.apache.org
Subject: more than one Excel-sheet with charts

Hello *,

is it possible (using HSSF 2.5), that I write some values into a
predefined Excel-template, which consists of two sheets: one with the
values, the second with a chart (pointing to the data of sheet #1)?

Imho the old 1.X HSSF POI isn't able to do that.

--
Regards,

Stefan Shoeman

---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/



 


This message has been scanned for viruses by BlackSpider MailControl - www.blackspider.com

---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/