MATLAB read/write/control Excel

What XLSREAD and XLSWRITE do under the hood

Description

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.

Acknowledgements

The author wishes to acknowledge the following in the creation of this submission:
write2excel

• MATLAB release: MATLAB 7.4 (R2007a)
• Other requirements: Windows only

[Jaspal Singh Chhokra]

 

[Curtis Egan]

This is a very nice tool, for interface to Excel. This should be very useful in the future to read and or write files from Excel and then plot this information.
It is much easier for me to document in excel than in Matlab.

[bilel haithem]

i want to execute a code matlab in excel

[rudolf kharpuri]

 

[Olivier Planchon]

This is more a tuto than a library or software.
Still, this just was what I needed to get the keys of easy communication with Excel