You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by nitin dubey <ni...@yahoo.com> on 2005/01/13 09:33:20 UTC
Data range for charts
Hello,
I have two sheets in a page. First sheet contains the
dat and the second contains an Area Chart/Line chart
based on the data in sheet 1. I would be pushing the
data to this sheet from database that should be
reflected into the chart.
My question is "Can we change the DataRange of a Chart
object already placed in an excel file ? If Yes how ?"
Regards,
Nitin Dubey
__________________________________
Do you Yahoo!?
Yahoo! Mail - Find what you need with new enhanced search.
http://info.mail.yahoo.com/mail_250
---------------------------------------------------------------------
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: AW: Data range for charts
Posted by nitin dubey <ni...@yahoo.com>.
Hi KHZ,
It violates the requirement. There should not be any
macros in the excel sheet. Any solution from Java end
? If it is possible then tell me .. coz if its not
possible I have to move on to explore another solution
i.e. OpenOffice API's.
Nitin
--- "KHZ (SAW)" <ka...@sawag.com> wrote:
> Hi Nitin.
>
> Mark your Excel file somehow so that when you open
> it next time the
> recalculation can be done using Excel macros.
>
> Regards, Karl-Heinz.
>
>
> -----Urspr�ngliche Nachricht-----
> Von: nitin dubey [mailto:nitz_tech@yahoo.com]
> Gesendet: Donnerstag, 13. Januar 2005 09:33
> An: poi-user@jakarta.apache.org
> Betreff: Data range for charts
>
> Hello,
>
> I have two sheets in a page. First sheet contains
> the
> dat and the second contains an Area Chart/Line chart
> based on the data in sheet 1. I would be pushing
> the
> data to this sheet from database that should be
> reflected into the chart.
>
> My question is "Can we change the DataRange of a
> Chart
> object already placed in an excel file ? If Yes how
> ?"
>
> Regards,
>
> Nitin Dubey
>
>
>
> __________________________________
> Do you Yahoo!?
> Yahoo! Mail - Find what you need with new enhanced
> search.
> http://info.mail.yahoo.com/mail_250
>
>
---------------------------------------------------------------------
> 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/
>
>
__________________________________
Do you Yahoo!?
Meet the all-new My Yahoo! - Try it today!
http://my.yahoo.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/
AW: Data range for charts
Posted by "KHZ (SAW)" <ka...@sawag.com>.
Hi Nitin.
Mark your Excel file somehow so that when you open it next time the
recalculation can be done using Excel macros.
Regards, Karl-Heinz.
-----Ursprüngliche Nachricht-----
Von: nitin dubey [mailto:nitz_tech@yahoo.com]
Gesendet: Donnerstag, 13. Januar 2005 09:33
An: poi-user@jakarta.apache.org
Betreff: Data range for charts
Hello,
I have two sheets in a page. First sheet contains the
dat and the second contains an Area Chart/Line chart
based on the data in sheet 1. I would be pushing the
data to this sheet from database that should be
reflected into the chart.
My question is "Can we change the DataRange of a Chart
object already placed in an excel file ? If Yes how ?"
Regards,
Nitin Dubey
__________________________________
Do you Yahoo!?
Yahoo! Mail - Find what you need with new enhanced search.
http://info.mail.yahoo.com/mail_250
---------------------------------------------------------------------
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/