Data import options to improve speed
12 次查看(过去 30 天)
显示 更早的评论
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 个评论
采纳的回答
the cyclist
2012-8-17
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 个评论
Suraj Srivastava
2015-4-30
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
更多回答(0 个)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!