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);
Zitieren als
Fahad Al Mahmood (2024). xlsheets (https://www.mathworks.com/matlabcentral/fileexchange/4474-xlsheets), MATLAB Central File Exchange. Abgerufen .
Kompatibilität der MATLAB-Version
Plattform-Kompatibilität
Windows macOS LinuxKategorien
- MATLAB > Data Import and Analysis > Data Import and Export > Standard File Formats > Spreadsheets >
- MATLAB > External Language Interfaces > COM with MATLAB > Use COM Objects in MATLAB >
Tags
Quellenangaben
Inspiriert von: xlswrite - legacy
Inspiriert: Example of how to save or read data to an Excel archive.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!Live Editor erkunden
Erstellen Sie Skripte mit Code, Ausgabe und formatiertem Text in einem einzigen ausführbaren Dokument.
Version | Veröffentlicht | Versionshinweise | |
---|---|---|---|
1.0.0.0 | Supporting Full or Partial Path |