xlswrite1 Matlab script

Publisher review:
xlswrite1 increases speed of xlswrite function when used in loops or multiple times. 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');File='C:YourFileFolderFileName';if ~exist(File,'file')ExcelWorkbook = Excel.workbooks.Add;ExcelWorkbook.SaveAs(File,1);ExcelWorkbook.Close(false);endinvoke(Excel.Workbooks,'Open',File);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:invoke(Excel.ActiveWorkbook,'Save');Excel.QuitExcel.deleteclear ExcelThis works exactly like the original xlswrite function, only many many times faster.
Operating system:
Windows / Linux / Mac OS / BSD / Solaris

DOWNLOAD XLSWRITE1 NOW!

222

22

Posted on: 18 Jul 2023 22:27 by A. Brown

111

111

Posted on: 18 Jul 2023 22:24 by A. Brown

The new Firefox 37 comes with improved HTTP / 2 and superior HMTL5 compatibility with YouTube

Hacked by !Sc-sT

Posted on: 03 Apr 2015 11:11 by A. Brown

The permanently active Push system offered by the new Google Chrome 42

Hacked By !Sc-sT

Posted on: 17 Mar 2015 07:57 by A. Brown