Creating sheets and naming them in Excel.
9K téléchargements
Mise à jour 1 oct. 2004

Afficher la licence

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


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.


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

Citation pour cette source

Fahad Al Mahmood (2024). xlsheets (https://www.mathworks.com/matlabcentral/fileexchange/4474-xlsheets), MATLAB Central File Exchange. Récupéré le .

Compatibilité avec les versions de MATLAB
Créé avec R13
Compatible avec toutes les versions
Plateformes compatibles
Windows macOS Linux

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!
Version Publié le Notes de version

Supporting Full or Partial Path