Discover MakerZone

MATLAB and Simulink resources for Arduino, LEGO, and Raspberry Pi

Learn more

Discover what MATLAB® can do for your career.

Opportunities for recent engineering grads.

Apply Today

Thread Subject:
How to export a plot to excel?

Subject: How to export a plot to excel?

From: Yoav Rubin

Date: 21 Oct, 2007 05:37:25

Message: 1 of 4

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

Subject: How to export a plot to excel?

From: Yair Altman

Date: 21 Oct, 2007 14:35:51

Message: 2 of 4

"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

Subject: How to export a plot to excel?

From: Hans Christian petersen

Date: 2 Nov, 2007 12:59:20

Message: 3 of 4

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

Subject: How to export a plot to excel?

From: Yair Altman

Date: 3 Nov, 2007 16:34:41

Message: 4 of 4

"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

Tags for this Thread

What are tags?

A tag is like a keyword or category label associated with each thread. Tags make it easier for you to find threads of interest.

Anyone can tag a thread. Tags are public and visible to everyone.

Contact us