Importing Data from Excel File 'Faster' ??

4 次查看（过去 30 天）
Mohamed Alaa
Mohamed Alaa 2011-3-2
Actually I'm working now on a GUI it's supposed that i have data (Matrix 2D of strings) like that :
A={'hello' 'world' 'hi';'my' 'name' is'};
it's simple,but I've put it in excel file and in the GUI m-file I've made a callback function that import that data from that file and save to a matrix and do some for loops to search for something inside this data . and finally saving the matrix back into the file .
THAT'S ACTUALLY CONSUMING TIME AND MY PROGRAM IS SLOW
Is there is a way to make it faster ? , Or any other solution ?
Thanks in Advance !
  5 个评论
显示 3更早的评论
Mohamed Alaa
Mohamed Alaa 2011-3-3
G=importdata('mydata.xls');
dvd=G.Sheet1;
f=size(dvd);
no_rows=f(1);
k=1;
%this is the simple part that searches but i do another operations before that to avoid spaces ,dots problems
search_object=get(handles.edit10,'string');
for i=1:no_rows
for j=1:6
f=regexp(dvd{i,j},New_search_object,'ignorecase','match');
R=isempty(f);
if R~=1
B{w}=sprintf('%d - %s',i,dvd{i,j});
w=w+1;
end
end
end
Oleg Komarov
Oleg Komarov 2011-3-3
I would:
- try to eliminate _importdata_
- definitely concentrate on the loops: no preallocation and regexp can also operate on cell arrays.
Try to post another thread with a meaningful example of the type of excel you usually have and more code.

请先登录，再进行评论。

请先登录，再回答此问题。

采纳的回答

Oleg Komarov
Oleg Komarov 2011-3-2
You can make it faster by using a modified version of xlsread modified version of xlsread
Oleg
  2 个评论
Matt Tearle
Matt Tearle 2011-3-2
Also note that xlsread/write are editable MATLAB code... meaning you can open them up, see how they work and copy bits and pieces. Hence, you can strip them down to the barest basics you need.

请先登录，再进行评论。

更多回答（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!

Translated by