xlswritefig

Write a MATLAB figure to a Microsoft Excel spreadsheet.

Description

XLSWRITEFIG allows you to programmatically place a MATLAB figure inside of an Excel spreadsheet. This can be a useful supplement to XLSWRITE.

• MATLAB release: MATLAB 7.6 (R2008a)
• Other requirements: Runs on Microsoft Windows only. Requires Excel.

[Peter Lindberg]

I've added a "add a new worksheet function":

WorkSheets = Excel.sheets;
message = struct('message',{''},'identifier',{''});

try
    Sheets = Excel.ActiveWorkBook.Sheets;
    target_sheet = get(Sheets, 'Item', sheetname);
catch %#ok<CTCH> Suppress so that this function works in releases without MException
    % Error if the sheet doesn't exist. It would be nice to create it, but
    % I'm too lazy.
    % The alternative to try/catch is to call xlsfinfo to see if the sheet exists, but
    % that's really slow.
    disp(['Sheet ' sheetname ' does not exist!']);
    Sheet = invoke(WorkSheets,'Add')
    Sheet.name = sheetname
    target_sheet = Sheet
end;

[Peter Lindberg]

 

[Anand]

Hello Scott,

Thanks for the M-File. Its very helpful.

I had few queries:
1. Can we resize the figure in Excel automatically.
2. I am running a loop, so the same set of instructions are iterated. Is there any way by which we could advance the cell where the figure has to be saved.

Any help is appreciated.

Thanks
Anand

[Peter Lindberg]

I changed line 80 to:

op = invoke(Excel.Workbooks, 'open', [filename]);

before it read:

op = invoke(Excel.Workbooks, 'open', [pwd filesep filename]);

but pwd filesep assumes you have the xl file in the same catalogue as your program. Just a thought.

[Krishna Kumar]

 

[Krishna Kumar]