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
Cite As
Michelle Hirsch (2026). xlswrite - legacy (https://github.com/michellehirsch/xlswrite--Legacy), GitHub. Retrieved .
MATLAB Release Compatibility
Platform Compatibility
Windows macOS LinuxCategories
- 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
Acknowledgements
Inspired: xlsheets, dat2xls, xlschart, XLSWriteMex, table2word, xlswrite_mod, xlcolumn, xlswrite, Example of how to save or read data to an Excel archive.
Discover Live Editor
Create scripts with code, output, and formatted text in a single executable document.
Versions that use the GitHub default branch cannot be downloaded
| Version | Published | Release Notes | |
|---|---|---|---|
| 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. |
