This code 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 I have just edited the original function by removing the server open and close function from the xlswrite function and moved them outside of the function. To use this first run the following code which opens the activex server and checks to see if the file already exists (creates if it doesnt):
Excel = actxserver ('Excel.Application');
ExcelWorkbook = Excel.workbooks.Add;
Then run the new xlswrite1 function as many times as needed or in a loop (for example xlswrite1(File,data,location). Then run the following code to close the activex server:
This works exactly like the original xlswrite function, only many many times faster.
Matt Swartz (2021). xlswrite1 (https://www.mathworks.com/matlabcentral/fileexchange/10465-xlswrite1), MATLAB Central File Exchange. Retrieved .
MATLAB Release Compatibility
Platform CompatibilityWindows macOS Linux
Inspired: wr_colwithheader, Tea Component Analysis, xlswrite_mod, saveppt2, Function for faster data transfer Matlab <--> Excel, xlswrite2007, MKXLSFUNC: Easily integrate legacy spreadsheet tools into MATLAB
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!Start Hunting!