xlswrite - legacy
NOTE: I built this a million years ago, before it was provided with MATLAB. I recommend you use xlswrite, or even better writetable, that have been in MATLAB for many years now.
Creates a Microsoft Excel format spreadsheet using the MATLAB ActiveX interface. This can also open the spreadsheet directly without ever saving to a file.
Nothing too fancy:
- Supports arbitrary number of header lines
- Supports column headers
- Writes a single matrix
- Can write to specific sheets (thanks Fahad!)
Example:
m = rand(100,4);
header = 'This is some introductory information at the top of my spreadsheet.';
colnames = {'Ch1','Ch2','Ch3','Ch4'};
filename = 'myfile.xls';
xlswrite(m,header,colnames,filename);
Will create a spreadsheet named myfile.xls
Zitieren als
Michelle Hirsch (2025). xlswrite - legacy (https://github.com/michellehirsch/xlswrite--Legacy), GitHub. 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: xlsheets, dat2xls, xlschart, XLSWriteMex, table2word, xlswrite_mod, xlcolumn, xlswrite, 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.
Versionen, die den GitHub-Standardzweig verwenden, können nicht heruntergeladen werden
Version | Veröffentlicht | Versionshinweise | |
---|---|---|---|
1.2.0.1 | Just updated description. |
|
|
1.2.0.0 | Moved code to GitHub. |
|
|
1.1.0.0 | minor changes to description and summary |
||
1.0.0.0 | Fix bug in how I compute column names. Thanks to Mark Hayworth for both finding and fixing the bug. |