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.
[status,message] = xlsWriteEx(myExcelFile1, myData1, ''Sheet1', 'A1');
[status,message] = xlsWriteEx(myExcelFile2, myData2, ''Sheet1', 'A1');
Nick Oatley (2022). xlsWriteEx (https://www.mathworks.com/matlabcentral/fileexchange/69745-xlswriteex), MATLAB Central File Exchange. Retrieved .
MATLAB Release Compatibility
Platform CompatibilityWindows macOS Linux
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!Start Hunting!