image thumbnail

MATLAB read/write/control Excel

version 1.0.0.0 (4.77 KB) by George Thiers
What XLSREAD and XLSWRITE do under the hood

4.4K Downloads

Updated 25 Jan 2008

No License

On a Windows platform, MATLAB's XLSREAD and XLSWRITE open Excel as a COM automation server in the background to read/write data. Sometimes users want XLSREAD and XLSWRITE to do more, and would like their own custom XLSREAD or XLSWRITE functions (such as a custom XLSWRITE that puts data into multiple worksheets, and creates Excel charts at the same time).

Little new functionality is contained in this submission compared to what is already contained in Brett Shoelson's submission referenced below. Whereas Brett Shoelson's "Write2Excel.m" is a cleanly packaged solution, this is an open script intended to show what's going on, to empower users to create their own enhanced XLSREAD and XLSWRITE.

Cite As

George Thiers (2021). MATLAB read/write/control Excel (https://www.mathworks.com/matlabcentral/fileexchange/18459-matlab-read-write-control-excel), MATLAB Central File Exchange. Retrieved .

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

Inspired by: write2excel

Community Treasure Hunt

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

Start Hunting!

XLSREAD/

XLSWRITE/