Thread Subject: How to export a plot to excel?

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

"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

"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 ?

"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