You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by Francesco Pellegrini <f....@telematicaitalia.it> on 2004/07/16 10:10:55 UTC
draw chart Excel using jakarta POI
Hi all,
I'm using a jakarta POI to build a report on excel files.
My environment is made up Tomcat 5.0.19, jdk 1.4.2 jakarta POI 1.5.1.
I need to improve final excel report by add more dynamic CHART,
I have checked jakarta API, but at moment it seeems not possible to draw
chart with POI Library.
Quy question are :
Is possible create chart with POI, isn't it?
Otherwise, how can i solve this issue???
Any help will be appreciated.
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org
RE: Can POI read (not create) split and freeze pane?
Posted by Paul Lee <pa...@skinnypigeon.com>.
I'll try, and will definitely patch it back should I succeed!
-----Original Message-----
From: Danny Mui [mailto:danny@muibros.com]
Sent: Monday, July 19, 2004 10:12 AM
To: POI Users List
Subject: Re: Can POI read (not create) split and freeze pane?
I dont think HSSF has read on that. Since I think we already have
"write" in, shouldn't be too hard to do the read portion.
It's only java and should be fun, dig in!!
Paul Lee wrote:
> Hi all,
>
> I am trying to use POI to find out if any WorkSheet has freeze/split panes
> and where.
>
> Searching the API, mailing list and web, the closest I find is HSSFSheet's
> createFreezePane() and createSplitPane(). I can't find anything like
> "getSplitPane()".
>
> Any clue to point me to the right direction would be greatly appreciated.
>
> Thanks,
> Paul
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: poi-user-help@jakarta.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org
Re: Can POI read (not create) split and freeze pane?
Posted by Danny Mui <da...@muibros.com>.
I dont think HSSF has read on that. Since I think we already have
"write" in, shouldn't be too hard to do the read portion.
It's only java and should be fun, dig in!!
Paul Lee wrote:
> Hi all,
>
> I am trying to use POI to find out if any WorkSheet has freeze/split panes
> and where.
>
> Searching the API, mailing list and web, the closest I find is HSSFSheet's
> createFreezePane() and createSplitPane(). I can't find anything like
> "getSplitPane()".
>
> Any clue to point me to the right direction would be greatly appreciated.
>
> Thanks,
> Paul
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: poi-user-help@jakarta.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org
Can POI read (not create) split and freeze pane?
Posted by Paul Lee <pa...@skinnypigeon.com>.
Hi all,
I am trying to use POI to find out if any WorkSheet has freeze/split panes
and where.
Searching the API, mailing list and web, the closest I find is HSSFSheet's
createFreezePane() and createSplitPane(). I can't find anything like
"getSplitPane()".
Any clue to point me to the right direction would be greatly appreciated.
Thanks,
Paul
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org
Re: draw chart Excel using jakarta POI
Posted by Glen Stampoultzis <gs...@iinet.net.au>.
Hi Francesco,
I started the chart work some time ago but never managed to get it
finished. It's a fairly big piece of work. More than I was able to handle
on a hobby basis so for the moment it's not going forward.
Regards,
Glen
At 06:10 PM 16/07/2004, you wrote:
>Hi all,
>
>I'm using a jakarta POI to build a report on excel files.
>
>My environment is made up Tomcat 5.0.19, jdk 1.4.2 jakarta POI 1.5.1.
>
>I need to improve final excel report by add more dynamic CHART,
>
>I have checked jakarta API, but at moment it seeems not possible to draw
>chart with POI Library.
>
>Quy question are :
>
>Is possible create chart with POI, isn't it?
>
>Otherwise, how can i solve this issue???
>
>
>Any help will be appreciated.
>
>
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
>For additional commands, e-mail: poi-user-help@jakarta.apache.org
Glen Stampoultzis
gstamp@iinet.net.au
http://members.iinet.net.au/~gstamp/glen/
Re: R: draw chart Excel using jakarta POI
Posted by Thomas Fromm <tf...@tfromm.com>.
> Where can I find API ?
Here is for example die XML format description for spread sheets:
http://msdn.microsoft.com/library/en-us/dnexcl2k2/html/odc_xmlss.asp
> Is it open source, or i need to buy this software solution,
The format descriptions are public available. You can use dom4j or similar XML
apis to create these xml documents.
If you want to use these documents also in older excel versions, you need a
converter for converting foobar.xml -> foobar.xls. But i haven't found such
java-based tool. Maybe its needed to use a binary tool for this conversion.
--
inubit - the integration experts Web: http://www.inubit.com
Thomas Fromm, inubit AG mailto:thomas.fromm@inubit.com
Lützowstraße 105-106, D-10785 Berlin
Freecall 0800-GoInUBIT, Tel +49(30)726112-135, Fax -100
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org
R: draw chart Excel using jakarta POI
Posted by Francesco Pellegrini <f....@telematicaitalia.it>.
Thanks Thomas for your answer,
Use excel 2002 XML format to descripe your document. Inside this xml format
there are also specifications for charts.
This can be one solution...
I'm not expert on excel XML format,
Where can I find API ?
Is it open source, or i need to buy this software solution,
Thanks in advance.
Francesco.
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org
Re: draw chart Excel using jakarta POI
Posted by Thomas Fromm <tf...@tfromm.com>.
Hi,
> Is possible create chart with POI, isn't it?
afaik not.
> Otherwise, how can i solve this issue???
Use excel 2002 XML format to descripe your document. Inside this xml format
there are also specifications for charts.
This can be one solution...
regards,
thomas
--
inubit - the integration experts Web: http://www.inubit.com
Thomas Fromm, inubit AG mailto:thomas.fromm@inubit.com
Lützowstraße 105-106, D-10785 Berlin
Freecall 0800-GoInUBIT, Tel +49(30)726112-135, Fax -100
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org