xlsWriteEx
This is an updated version of Matt Swartz's xlswrite1, which increases the speed of the xlswrite function when used in loops or multiple times. The problem with the original function is that it opens and closes the Excel server every time the function is used. To increase the speed the Excel server is kept open after a call to the function.
Usage is exactly the same as the built-in xlswrite function except that when done, a call to xlsWriteEx with no input parameters is required to close the Excel server.
For example:
[status,message] = xlsWriteEx(myExcelFile1, myData1, ''Sheet1', 'A1');
[status,message] = xlsWriteEx(myExcelFile2, myData2, ''Sheet1', 'A1');
xlsWriteEx;
Cite As
Nick Oatley (2024). xlsWriteEx (https://www.mathworks.com/matlabcentral/fileexchange/69745-xlswriteex), MATLAB Central File Exchange. Retrieved .
MATLAB Release Compatibility
Platform Compatibility
Windows macOS LinuxCategories
Tags
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!Discover Live Editor
Create scripts with code, output, and formatted text in a single executable document.
Version | Published | Release Notes | |
---|---|---|---|
1.0.0 |