xlswrite - legacy

Easily create a Microsoft Excel format spreadsheet from MATLAB®.
34.7K Downloads
Updated 4 Dec 2019

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 (2024). xlswrite - legacy (https://github.com/michellehirsch/xlswrite--Legacy), GitHub. Retrieved .

MATLAB Release Compatibility
Created with R2019b
Compatible with any release
Platform Compatibility
Windows macOS Linux

Community Treasure Hunt

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

Start Hunting!

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.

To view or report issues in this GitHub add-on, visit the GitHub Repository.
To view or report issues in this GitHub add-on, visit the GitHub Repository.