Code covered by the BSD License  

Highlights from
improved xlswrite.m

5.0

5.0 | 8 ratings Rate this file 73 Downloads (last 30 days) File Size: 6.12 KB File ID: #27236

improved xlswrite.m

by

 

Makes xlswrite use 'persistent' actxserver and hence much faster

| Watch this File

File Information
Description

If writing or reading repeatedly to same spreadsheets very slow to keep creating and deleting the active x server. These extra 4 lines of code cause xlswrite to remember if you accessed this spreadsheet before and then not re-create the active x server.

Acknowledgements

This file inspired Despiking Acoustic Doppler Velocimeter (Adv) Data.

MATLAB release MATLAB 7.9 (R2009b)
Tags for This File   Please login to tag files.
Please login to add a comment or rating.
Comments and Ratings (10)
16 Sep 2014 Dave Perry

THANK-YOU x 10! - this code works much faster than the original version (on Win7 - 32b - with 2013a)

21 May 2014 Marco Marino

With just 4 lines of code my script has become 4 times faster!

Cheers man!

02 May 2013 Victor  
27 Mar 2013 Daniel  
27 Mar 2013 Daniel

Oh my god, I can't thank you enough!! I am using MATLAB to locate particles in over 9,000 images and then write location data to excel. This has sped things up incredibly!

03 Aug 2012 K E

Do I need to rename this to xlswrite1.m to distinguish it from the builtin xlswrite?

28 Nov 2011 Sebastian W

I optimized my program before I found this and only got 3 write commands left, but this new xlswrite function is roughly 10 times faster.
Thanks Barry.

31 Jul 2011 Fernando tyffing

Works very good, priori to using this it was impossible to run parfor creating a lot of xls files.

11 Nov 2010 Stan Young

Does this leave anything open in the background that would be of concern if writing a large number of spreadsheets - sort of like leaving file pointers open?

04 Jul 2010 Milkykung

Thank you very much for your effort in going into details of ActiveX server when dealing with xls file using MATLAB.

I have to admit that I have no clue what is going when my xlswrite is running as I know superficially that ActiveX server has to be created and I simply use it. I realise your powerful correction of the xlswrite when I struggle to run 7-8 lines of xlswrite continuosly for 360 times and it kept crashing. I have been trying to run it for 2-3 days and it ends up the same way sooner or later. I have to divide it and run seperately but still a painful delay causes freezing several times.

I totally appreciate on what you have done on this and your contribution is highly regarded as a life and time-saver. I can have my program running and getting results thanks to you.

Thank you very much again and please keep it up.

Kind regards,

Contact us