You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by Ru...@external.mckinsey.com on 2007/11/08 10:24:15 UTC
Create chart in Excel and export the image to PPT
Hi,
I want to create PPT reports using POI but I was informed that directly
creating and updating the chart objects in PPT is not yet possible.
I was thinking of an alternative approach.
1. Create chart using Excel.
2. Export the chart to PPT slide as an image.
Has anyone tried this approach or individual steps. If yes, then please
send in any sample code which would be useful to implement these steps.
I need to implement it urgently so your help will be highly appreciated.
Thanks & Regards,
Rushabh Raval
+=========================================================+
This message may contain confidential and/or privileged
information. If you are not the addressee or authorized to
receive this for the addressee, you must not use, copy,
disclose or take any action based on this message or any
information herein. If you have received this message in
error, please advise the sender immediately by reply e-mail
and delete this message. Thank you for your cooperation.
+=========================================================+
Re: Create chart in Excel and export the image to PPT
Posted by Anthony Andrews <py...@yahoo.com>.
Ah, sorry. Cannot be of any help there. Best of luck.
Rushabh_Raval@external.mckinsey.com wrote: Hi Anthony,
Thanks for your response.
But I need to create the ppt from my Java code hence I need to find a
solution where I could generate a ppt with charts from my Java code.
The solution suggested by you is the manual procedure to embed objects, I
was aware of that but I wanted to know if this could be achieved through
my java code.
Thanks & Regards,
Rushabh Raval
Anthony Andrews
11/09/2007 03:50 PM
Please respond to
"POI Users List"
To
POI Users List
cc
Subject
Re: Create chart in Excel and export the image to PPT
Just read the last section of that message back and it does not make
sense, sorry.
The two options are to link to the file - when you will see any changes
made reflected in the Powerpoint document and to embed the .xls file when
you will not see any changes made reflected. Sorry about the mistake.
Anthony Andrews
wrote: You do not use POI at all
for this, just the two Office products.
I have to say that I do not know if PowerPoint supports this type of
funtionality but I would be very surprised if it did not because MS were
one of the innovators behind OLE.
Anyway, you will do something like this;
Create the chart using Excel and save the .xls file away somewhere -
remembering where of course.
Create the PowerPoint presentation and at the place you wish to see the
Excel chart insert an object that you will create from that Excel .xls
file. I do not have PowerPoint on this PC and con only say what you would
do using Word for example; that process is; Click on the Insert menu in
the MenuBar, from the drop down menu, select Object and then one the pop
up that is displayed select Create from file. Now simply navigate your way
to that .xls file you saved.
There are usually two option, to inert the object or to embed it. If you
insert the object you will not see any changes you may subsequently make
reflected in the PowerPoint slide. If you embed it the you will see
changes reflected.
Have a look at this link;
http://msdn2.microsoft.com/en-us/library/aa168127(office.11).aspx
It looks at some of the problems you may encounter if you choose to follow
this suggestion.
Rushabh_Raval@external.mckinsey.com wrote: Hi,
And how would I achieve that?
How do I save the chart in Excel as an object using POI?
How do I embed that object in powerpoint using POI?
Thanks & Regards,
Rushabh Raval
Anthony Andrews
11/08/2007 06:23 PM
Please respond to
"POI Users List"
To
POI Users List
cc
Subject
Re: Create chart in Excel and export the image to PPT
I know this probably sounds old fashioned, but would it not be possible to
use OLE - could you simply embed the Excel chart as an object into the PPT
slide?
Yegor Kozlov wrote: Hi,
> 1. Create chart using Excel.
> 2. Export the chart to PPT slide as an image.
To link steps 1 and 2 you need to convert the Excel chart into an
image. Unfortunately there is no way in POI to export/render Excel
charts into images.
Regards,
Yegor
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
+=========================================================+
This message may contain confidential and/or privileged
information. If you are not the addressee or authorized to
receive this for the addressee, you must not use, copy,
disclose or take any action based on this message or any
information herein. If you have received this message in
error, please advise the sender immediately by reply e-mail
and delete this message. Thank you for your cooperation.
+=========================================================+
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
+=========================================================+
This message may contain confidential and/or privileged
information. If you are not the addressee or authorized to
receive this for the addressee, you must not use, copy,
disclose or take any action based on this message or any
information herein. If you have received this message in
error, please advise the sender immediately by reply e-mail
and delete this message. Thank you for your cooperation.
+=========================================================+
---------------------------------
Be a better sports nut! Let your teams follow you with Yahoo Mobile. Try it now.
Re: Create chart in Excel and export the image to PPT
Posted by Ru...@external.mckinsey.com.
Hi Anthony,
Thanks for your response.
But I need to create the ppt from my Java code hence I need to find a
solution where I could generate a ppt with charts from my Java code.
The solution suggested by you is the manual procedure to embed objects, I
was aware of that but I wanted to know if this could be achieved through
my java code.
Thanks & Regards,
Rushabh Raval
Anthony Andrews <py...@yahoo.com>
11/09/2007 03:50 PM
Please respond to
"POI Users List" <us...@poi.apache.org>
To
POI Users List <us...@poi.apache.org>
cc
Subject
Re: Create chart in Excel and export the image to PPT
Just read the last section of that message back and it does not make
sense, sorry.
The two options are to link to the file - when you will see any changes
made reflected in the Powerpoint document and to embed the .xls file when
you will not see any changes made reflected. Sorry about the mistake.
Anthony Andrews <py...@yahoo.com> wrote: You do not use POI at all
for this, just the two Office products.
I have to say that I do not know if PowerPoint supports this type of
funtionality but I would be very surprised if it did not because MS were
one of the innovators behind OLE.
Anyway, you will do something like this;
Create the chart using Excel and save the .xls file away somewhere -
remembering where of course.
Create the PowerPoint presentation and at the place you wish to see the
Excel chart insert an object that you will create from that Excel .xls
file. I do not have PowerPoint on this PC and con only say what you would
do using Word for example; that process is; Click on the Insert menu in
the MenuBar, from the drop down menu, select Object and then one the pop
up that is displayed select Create from file. Now simply navigate your way
to that .xls file you saved.
There are usually two option, to inert the object or to embed it. If you
insert the object you will not see any changes you may subsequently make
reflected in the PowerPoint slide. If you embed it the you will see
changes reflected.
Have a look at this link;
http://msdn2.microsoft.com/en-us/library/aa168127(office.11).aspx
It looks at some of the problems you may encounter if you choose to follow
this suggestion.
Rushabh_Raval@external.mckinsey.com wrote: Hi,
And how would I achieve that?
How do I save the chart in Excel as an object using POI?
How do I embed that object in powerpoint using POI?
Thanks & Regards,
Rushabh Raval
Anthony Andrews
11/08/2007 06:23 PM
Please respond to
"POI Users List"
To
POI Users List
cc
Subject
Re: Create chart in Excel and export the image to PPT
I know this probably sounds old fashioned, but would it not be possible to
use OLE - could you simply embed the Excel chart as an object into the PPT
slide?
Yegor Kozlov wrote: Hi,
> 1. Create chart using Excel.
> 2. Export the chart to PPT slide as an image.
To link steps 1 and 2 you need to convert the Excel chart into an
image. Unfortunately there is no way in POI to export/render Excel
charts into images.
Regards,
Yegor
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
+=========================================================+
This message may contain confidential and/or privileged
information. If you are not the addressee or authorized to
receive this for the addressee, you must not use, copy,
disclose or take any action based on this message or any
information herein. If you have received this message in
error, please advise the sender immediately by reply e-mail
and delete this message. Thank you for your cooperation.
+=========================================================+
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
+=========================================================+
This message may contain confidential and/or privileged
information. If you are not the addressee or authorized to
receive this for the addressee, you must not use, copy,
disclose or take any action based on this message or any
information herein. If you have received this message in
error, please advise the sender immediately by reply e-mail
and delete this message. Thank you for your cooperation.
+=========================================================+
Re: Create chart in Excel and export the image to PPT
Posted by Anthony Andrews <py...@yahoo.com>.
Just read the last section of that message back and it does not make sense, sorry.
The two options are to link to the file - when you will see any changes made reflected in the Powerpoint document and to embed the .xls file when you will not see any changes made reflected. Sorry about the mistake.
Anthony Andrews <py...@yahoo.com> wrote: You do not use POI at all for this, just the two Office products.
I have to say that I do not know if PowerPoint supports this type of funtionality but I would be very surprised if it did not because MS were one of the innovators behind OLE.
Anyway, you will do something like this;
Create the chart using Excel and save the .xls file away somewhere - remembering where of course.
Create the PowerPoint presentation and at the place you wish to see the Excel chart insert an object that you will create from that Excel .xls file. I do not have PowerPoint on this PC and con only say what you would do using Word for example; that process is; Click on the Insert menu in the MenuBar, from the drop down menu, select Object and then one the pop up that is displayed select Create from file. Now simply navigate your way to that .xls file you saved.
There are usually two option, to inert the object or to embed it. If you insert the object you will not see any changes you may subsequently make reflected in the PowerPoint slide. If you embed it the you will see changes reflected.
Have a look at this link;
http://msdn2.microsoft.com/en-us/library/aa168127(office.11).aspx
It looks at some of the problems you may encounter if you choose to follow this suggestion.
Rushabh_Raval@external.mckinsey.com wrote: Hi,
And how would I achieve that?
How do I save the chart in Excel as an object using POI?
How do I embed that object in powerpoint using POI?
Thanks & Regards,
Rushabh Raval
Anthony Andrews
11/08/2007 06:23 PM
Please respond to
"POI Users List"
To
POI Users List
cc
Subject
Re: Create chart in Excel and export the image to PPT
I know this probably sounds old fashioned, but would it not be possible to
use OLE - could you simply embed the Excel chart as an object into the PPT
slide?
Yegor Kozlov wrote: Hi,
> 1. Create chart using Excel.
> 2. Export the chart to PPT slide as an image.
To link steps 1 and 2 you need to convert the Excel chart into an
image. Unfortunately there is no way in POI to export/render Excel
charts into images.
Regards,
Yegor
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
+=========================================================+
This message may contain confidential and/or privileged
information. If you are not the addressee or authorized to
receive this for the addressee, you must not use, copy,
disclose or take any action based on this message or any
information herein. If you have received this message in
error, please advise the sender immediately by reply e-mail
and delete this message. Thank you for your cooperation.
+=========================================================+
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
Re: Create chart in Excel and export the image to PPT
Posted by Anthony Andrews <py...@yahoo.com>.
You do not use POI at all for this, just the two Office products.
I have to say that I do not know if PowerPoint supports this type of funtionality but I would be very surprised if it did not because MS were one of the innovators behind OLE.
Anyway, you will do something like this;
Create the chart using Excel and save the .xls file away somewhere - remembering where of course.
Create the PowerPoint presentation and at the place you wish to see the Excel chart insert an object that you will create from that Excel .xls file. I do not have PowerPoint on this PC and con only say what you would do using Word for example; that process is; Click on the Insert menu in the MenuBar, from the drop down menu, select Object and then one the pop up that is displayed select Create from file. Now simply navigate your way to that .xls file you saved.
There are usually two option, to inert the object or to embed it. If you insert the object you will not see any changes you may subsequently make reflected in the PowerPoint slide. If you embed it the you will see changes reflected.
Have a look at this link;
http://msdn2.microsoft.com/en-us/library/aa168127(office.11).aspx
It looks at some of the problems you may encounter if you choose to follow this suggestion.
Rushabh_Raval@external.mckinsey.com wrote: Hi,
And how would I achieve that?
How do I save the chart in Excel as an object using POI?
How do I embed that object in powerpoint using POI?
Thanks & Regards,
Rushabh Raval
Anthony Andrews
11/08/2007 06:23 PM
Please respond to
"POI Users List"
To
POI Users List
cc
Subject
Re: Create chart in Excel and export the image to PPT
I know this probably sounds old fashioned, but would it not be possible to
use OLE - could you simply embed the Excel chart as an object into the PPT
slide?
Yegor Kozlov wrote: Hi,
> 1. Create chart using Excel.
> 2. Export the chart to PPT slide as an image.
To link steps 1 and 2 you need to convert the Excel chart into an
image. Unfortunately there is no way in POI to export/render Excel
charts into images.
Regards,
Yegor
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
+=========================================================+
This message may contain confidential and/or privileged
information. If you are not the addressee or authorized to
receive this for the addressee, you must not use, copy,
disclose or take any action based on this message or any
information herein. If you have received this message in
error, please advise the sender immediately by reply e-mail
and delete this message. Thank you for your cooperation.
+=========================================================+
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
Re: Create chart in Excel and export the image to PPT
Posted by Ru...@external.mckinsey.com.
Hi,
And how would I achieve that?
How do I save the chart in Excel as an object using POI?
How do I embed that object in powerpoint using POI?
Thanks & Regards,
Rushabh Raval
Anthony Andrews <py...@yahoo.com>
11/08/2007 06:23 PM
Please respond to
"POI Users List" <us...@poi.apache.org>
To
POI Users List <us...@poi.apache.org>
cc
Subject
Re: Create chart in Excel and export the image to PPT
I know this probably sounds old fashioned, but would it not be possible to
use OLE - could you simply embed the Excel chart as an object into the PPT
slide?
Yegor Kozlov <ye...@dinom.ru> wrote: Hi,
> 1. Create chart using Excel.
> 2. Export the chart to PPT slide as an image.
To link steps 1 and 2 you need to convert the Excel chart into an
image. Unfortunately there is no way in POI to export/render Excel
charts into images.
Regards,
Yegor
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
+=========================================================+
This message may contain confidential and/or privileged
information. If you are not the addressee or authorized to
receive this for the addressee, you must not use, copy,
disclose or take any action based on this message or any
information herein. If you have received this message in
error, please advise the sender immediately by reply e-mail
and delete this message. Thank you for your cooperation.
+=========================================================+
Re: Create chart in Excel and export the image to PPT
Posted by Anthony Andrews <py...@yahoo.com>.
I know this probably sounds old fashioned, but would it not be possible to use OLE - could you simply embed the Excel chart as an object into the PPT slide?
Yegor Kozlov <ye...@dinom.ru> wrote: Hi,
> 1. Create chart using Excel.
> 2. Export the chart to PPT slide as an image.
To link steps 1 and 2 you need to convert the Excel chart into an
image. Unfortunately there is no way in POI to export/render Excel
charts into images.
Regards,
Yegor
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
Re: Create chart in Excel and export the image to PPT
Posted by Yegor Kozlov <ye...@dinom.ru>.
Hi,
> 1. Create chart using Excel.
> 2. Export the chart to PPT slide as an image.
To link steps 1 and 2 you need to convert the Excel chart into an
image. Unfortunately there is no way in POI to export/render Excel
charts into images.
Regards,
Yegor
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org