Data import options to improve speed
显示 更早的评论
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');
采纳的回答
the cyclist
2012-8-17
0 个投票
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 个评论
Karl Broer
2012-8-19
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 个）
类别
在 帮助中心 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
