MATLAB Central Newsreader - How to export a plot to excel?

How to export a plot to excel?

Yoav Rubin — Sun, 21 Oct 2007 05:37:25 -0400

Hi All,

I have a plot with several line in it (using hold off), and
I'd like somehow to export this plot to excel, so that in
the excel file I'll have a similar graph, with the similar
lines. Can i do it or do I have to use xlswrite to export
all the XDatas and YDatas of the lines and afterwards
manually re-build the graph in excel?

Thanks
Yoav

Re: How to export a plot to excel?

Yair Altman — Sun, 21 Oct 2007 14:35:51 -0400

"Yoav Rubin" <yoavrubin@hotmail.com> wrote in message
<ffeoil$ipv$1@fred.mathworks.com>...
> Hi All,
>
> I have a plot with several line in it (using hold off), and
> I'd like somehow to export this plot to excel, so that in
> the excel file I'll have a similar graph, with the similar
> lines. Can i do it or do I have to use xlswrite to export
> all the XDatas and YDatas of the lines and afterwards
> manually re-build the graph in excel?
>
> Thanks
> Yoav

You can export a screenshot of the plot using OfficeDoc -
http://www.mathworks.com/matlabcentral/fileexchange/loadFile.do?objectId=15192&objectType=FILE

Yair Altman
http://ymasoftware.com

Re: How to export a plot to excel?

Hans Christian petersen — Fri, 02 Nov 2007 12:59:20 -0400

"Yoav Rubin" <yoavrubin@hotmail.com> wrote in message
<ffeoil$ipv$1@fred.mathworks.com>...
> Hi All,
>
> I have a plot with several line in it (using hold off),
and
> I'd like somehow to export this plot to excel, so that in
> the excel file I'll have a similar graph, with the similar
> lines. Can i do it or do I have to use xlswrite to export
> all the XDatas and YDatas of the lines and afterwards
> manually re-build the graph in excel?
>
> Thanks
> Yoav
>
> Hi all,
I have the same problem as Yoav needing a Matlab figure
inserted in an Excel sheet. Using the free version of
OfficeDoc on an existing workbook resulted in a picture on
sheet1 allright but also that a couple of nondefault sheets
containing data were deleted !!! (I did use the append mode
when opening )
Is the proffesional version of OfficeDoc any better ?

Re: How to export a plot to excel?

Yair Altman — Sat, 03 Nov 2007 16:34:41 -0400

"Hans Christian petersen" <hcpetersen2@sauer-danfoss.com>
wrote in message <fgf6v8$6ls$1@fred.mathworks.com>...
> "Yoav Rubin" <yoavrubin@hotmail.com> wrote in message
> <ffeoil$ipv$1@fred.mathworks.com>...
> > Hi All,
> >
> > I have a plot with several line in it (using hold off),
> and
> > I'd like somehow to export this plot to excel, so that in
> > the excel file I'll have a similar graph, with the similar
> > lines. Can i do it or do I have to use xlswrite to export
> > all the XDatas and YDatas of the lines and afterwards
> > manually re-build the graph in excel?
> >
> > Thanks
> > Yoav
> >
> > Hi all,
> I have the same problem as Yoav needing a Matlab figure
> inserted in an Excel sheet. Using the free version of
> OfficeDoc on an existing workbook resulted in a picture on
> sheet1 allright but also that a couple of nondefault sheets
> containing data were deleted !!! (I did use the append mode
> when opening )
> Is the proffesional version of OfficeDoc any better ?

No Excel sheets should have been deleted unless the 'DelStd'
parameter was specifically requested. The professional
version is no different than the free version in this respect.

Please post you OfficeDoc commands and Excel worksheet names
here (or email me directly) and I'll try to figure out the
problem.

Thanks,
Yair Altman
http://ymasoftware.com