MATLAB Central Newsreader - Saving figures to Excel

Saving figures to Excel

Anthony — Mon, 17 Sep 2007 20:38:40 -0400

Is there a feature in MATLAB that will allow me to save a
figure to an Excel sheet, just like xlswrite where I give
it a cell to save it to

Re: Saving figures to Excel

Yair Altman — Mon, 17 Sep 2007 20:55:31 -0400

"Anthony " <anthony.campos@baesystems.com> wrote in message
<fcmokg$n4l$1@fred.mathworks.com>...
> Is there a feature in MATLAB that will allow me to save a
> figure to an Excel sheet, just like xlswrite where I give
> it a cell to save it to

Use OfficeDoc on the file Exchange:
http://www.mathworks.com/matlabcentral/fileexchange/loadFile.do?objectId=15192

Yair Altman
http://ymasoftware.com

Re: Saving figures to Excel

Anthony — Tue, 18 Sep 2007 13:53:34 -0400

I tried the officedoc command
[file,status,errMsg] = officedoc
('tx_compare_rates.xls', 'open', 'mode','append');
status = officedoc(file,'write',rate2,'H1:P23',
[figsavemag '.fig']);

and received the following error:
??? Error setting officedoc property '6 MHz':
Invalid field name: '6 mhz'.

Error in ==> tx_compare_rates at 135
status = officedoc(file,'write',rate2,'H1:P23',
[figsavemag '.fig']);

I want to write a bitmap or the .fig file to the H1 cell,
to the rate2 sheet, where rate2 = '6 Mhz', and file

"Anthony " <anthony.campos@baesystems.com> wrote in message
<fcmokg$n4l$1@fred.mathworks.com>...
> Is there a feature in MATLAB that will allow me to save a
> figure to an Excel sheet, just like xlswrite where I give
> it a cell to save it to

Re: Saving figures to Excel

Yair Altman — Tue, 18 Sep 2007 18:47:26 -0400

> status = officedoc(file,'write',rate2,'H1:P23',[figsavemag
'.fig']);
>
> and received the following error:
> ??? Error setting officedoc property '6 MHz':
> Invalid field name: '6 mhz'.

Following 'write', you need to specify properties in
name-value (P-V) pairs. In your case:

status=officedoc(file,'write','sheet',rate2,'range','H1:P23','image',myImage);

the supplied myImage parameter may be an image filename or a
handle to a Matlab figure.

Yair Altman
http://ymasoftware.com