Rank: 913 based on 152 downloads (last 30 days) and 1 file submitted
photo

Matt Swartz

E-mail

Personal Profile:
Professional Interests:

 

Watch this Author's files

 

Files Posted by Matt
Updated   File Tags Downloads
(last 30 days)
Comments Rating
21 Mar 2006 xlswrite1 increases speed of xlswrite function when used in loops or multiple times. Author: Matt Swartz data import, data export, xlswrite increased sp... 152 49
  • 4.86111
4.9 | 37 ratings
Comments and Ratings on Matt's Files View all
Updated File Comment by Comments Rating
23 Jul 2014 xlswrite1 increases speed of xlswrite function when used in loops or multiple times. Author: Matt Swartz Irene

Hello, I have a little problem running this function.
I opened the activex server and all, specifing an existing .xls file, and also changed the second line of the script with 'caller', but still is giving me an error.

The error I got is:

Error using xlswrite1 (line 143)
Error: Object returned error code: 0x800A03EC

Error in xlswrite1 (line 143)
error('MATLAB:xlswrite:SelectDataRange',lasterr);

The error seems to be in the range I specify, but I call it as I used to do with xlswrite, so having something like 'A1:B1'.

I'm working on windows 7, matlab 2012b and excel 2007 (italian version, thus the sheet is originally named as 'Foglio1' instead of 'Sheet1', but I also have manually changed it in the xls file).
Thank you very much in advance.

23 Jul 2014 xlswrite1 increases speed of xlswrite function when used in loops or multiple times. Author: Matt Swartz Sheldon

ActiveX is not available on Mac OS. So this solution is Windows only. If you are doing a lot of xls writing on a Mac, I'd suggest using csvwrite, which is much quicker than xlswrite, and then just opening the csv in Excel.

A csv file, is a text document, with each column separated by a comma and each row on a new line. It can be opened in Excel, and quite easily saved as an excel file.

17 Jun 2014 xlswrite1 increases speed of xlswrite function when used in loops or multiple times. Author: Matt Swartz katerina

i changed from 'base' to 'caller' on line two, and also checked the task manager. it still doesn't work. what am i missing?? i would love to benefit from faster excel accesses.

11 Jun 2014 xlswrite1 increases speed of xlswrite function when used in loops or multiple times. Author: Matt Swartz Gee, Clark

26 Feb 2014 xlswrite1 increases speed of xlswrite function when used in loops or multiple times. Author: Matt Swartz Bert

Contact us