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.
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
Platform CompatibilityWindows macOS Linux
Inspired by: write2excel
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!Start Hunting!