XLSWriteMex

MATLAB MEX function to create an Excel spreadsheet.

Description

Functionally the same xlswrite.m (by Scott Hirsch), the only difference is in the implementation.

XLSWriteMex is implemented in C++ and compiled into a MATLAB MEX dll. I did this because 'xlswrite.m' does not compile using the MATLAB compiler, so any MATLAB program using 'xlswrite.m' cannot be compiled into a stand-alone app.

Using XLSWriteMex instead of xlswrite will solve this problem.

Example using XLSWriteMex:
m = rand(100,4);
header = 'This is some introductory information at the top of my spreadsheet.';
colnames = {'Ch1','Ch2','Ch3','Ch4'};
filename = 'myfile.xls';
XLSWriteMex(m,header,colnames,filename);

Will create a spreadsheet named myfile.xls

Acknowledgements

The author wishes to acknowledge the following in the creation of this submission:
xlswrite
This submission has inspired the following:
Example of how to save or read data to an Excel archive.

• MATLAB release: MATLAB 6.5 (R13)
• Other requirements: Microsoft Excel

[martyn dorey]

Nice

[Jean Ghanem]

Very nice

[Garner Zuir]

Interesting and useful

[Wan an Cui]

very good!

[Wan an Cui]

 

[Wan an Cui]

Very good! If the author can add path to the created file,it will be more excellent.
For example, I hope the created file in "D:\mywork\Matlab",but I do not know how to realize it. Thanks the author.

[Liaquat Iqbal]

 

[George]

Is there a way to use the functionality of the built in xlswrite function with this file?
Instead of "XLSWriteMex(m,header,colnames,filename)"
is there a way to use "xlswrite(File,data,sheet,location)" in a compiled version?

[Mechanical Design Engineering Mohamed]

Where to paste this file??
i have an error undefined function or command

[Daniele]

It's not clear how the DLL should be loaded. Where does the file/folder need to be placed? Does it need to be loaded with 'loadlibrary'? Please include a readme file with instructions. Thanks