Data import options to improve speed
12 views (last 30 days)
Show older comments
I'm running a program where I bring in several matrices of data from a MS Excel file using the xlsread() function. I want to make my code run faster, and the importing steps are currently consuming most of the run time of the code. Are there any ways that I can improve the speed via the following conceptual strategies:
1.) Only import the excel data once per work session, rather than every time I run the sequence of calculations.
2.) Move the Excel data to some other kind of file that Matlab can read faster, and import from that file instead of from Excel.
Here's an example of one of the code lines that I'm using that is running kinda slow:
ReacParam = xlsread('H2_O2 System3','Rxn Parameters','B2:D22');
0 Comments
Accepted Answer
the cyclist
on 17 Aug 2012
The slowness comes primarily from the opening and closing of the Excel file. If you are working with just one Excel file, try this entry from the FEX:
It is a modified version of xlswrite that assumes the file is open already. (It explains how to open the file for the first read.)
3 Comments
Suraj Srivastava
on 30 Apr 2015
Hi,
Colud you please tell me that, How can I use xlswrite1 in GUI. I have used it, but it gives error.
Any comment is appreciated.
Thanks, Suraj
More Answers (0)
See Also
Categories
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!