xlsheets

Creating sheets and naming them in Excel.

Description

Creates new Excel file (or opens it if file exists) and name the sheets as listed in (sheetnames) and saves the workbook as (filename).

xlsheets(sheetnames,filename)
xlsheets(sheetnames)

sheetnames: List of sheet names (cell array).
filename: Name of excel file.

NOTE: Follow the following rules when naming your sheets:
1- Make sure the name you entered does not exceed 31 characters.
2- Make sure the name does not contain any of the following characters:
: \ / ? * [ or ]
3- Make sure you did not leave the name blank.
4- Make sure each sheet name is a character string.
5- Make sure you do not have two sheets or more with the same name.

Example:

sheetnames = {'Mama','Papa','Son','Daughter','Dog'};
filename = 'family.xls';
xlsheets(sheetnames,filename);
xlsheets(sheetnames);

Acknowledgements

The author wishes to acknowledge the following in the creation of this submission:
xlswrite

• MATLAB release: MATLAB 6.5 (R13)
• Other requirements: Microsoft Excel

[Rashid Al mannai]

Very useful program

[Udya Desai]

 

[Gourihar Kulkarni]

An extraordinary .m file. I appreciate
your contribution to scientific community.
Many thanks.

[avi pinsker]

Thak you very much, very usefull a program.
only one problem:
Invoke Error, Dispatch Exception: An attempt was made to load a program with an incorrect format
how do I fix this ?

[bean bean]

 

[Exo Sceleton]

Thank you for your sharing mentality.
Just the lines of code i needed.

[Andrew Wilson]

Works perfectly and solves a problem for me. The work is much appreciated.

[Tina Tseng]