image thumbnail

xlsWriteEx

version 1.0.0 (4.99 KB) by Nick Oatley
Updated version of xlswrite1 for faster writing to Excel, based on R2018b

313 Downloads

Updated 17 Dec 2018

View License

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 (2022). xlsWriteEx (https://www.mathworks.com/matlabcentral/fileexchange/69745-xlswriteex), MATLAB Central File Exchange. Retrieved .

MATLAB Release Compatibility
Created with R2018b
Compatible with R2018b and later releases
Platform Compatibility
Windows macOS Linux

Community Treasure Hunt

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

Start Hunting!