Rename Excel sheet name in Matlab

Question

I am creating Excel using the matlab xlswrite function. How can I change the name of the first sheet of this excel document? (I read the official help at Matlab, but I did not find any solution).

Answer 1

You can use ActiveX directly from MATLAB:

xlswrite('test.xls',1) % # create test file

e = actxserver('Excel.Application'); % # open Activex server
ewb = e.Workbooks.Open('c:\test\test.xls'); % # open file (enter full path!)
ewb.Worksheets.Item(1).Name = 'new name'; % # rename 1st sheet
ewb.Save % # save to the same file
ewb.Close(false)
e.Quit

Be careful during testing, it overwrites the original file. Make a backup.

Answer 2

A quick link to help you do this:

http://www.mathworks.com/matlabcentral/fileexchange/4474-xlsheets/content/xlsheets.m