xlsWriteEx

Updated version of xlswrite1 for faster writing to Excel, based on R2018b

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;