Scott Hirsch

I love it. Not sure how I got along for 15 years without it! One small note - the "last" syntax actually keeps the current figure open, which wasn't necessarily the last one created. I love this behavior so much, that I tweaked CAB to do this with no input arguments, too.

Thanks for a simple, elegant, and very useful function.

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

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;