this code is taking a lot of time to run,

3 次查看（过去 30 天）

Prajwal Venkatesh 2020-1-17

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/500800-this-code-is-taking-a-lot-of-time-to-run

评论： Prajwal Venkatesh 2020-1-19

Is there anyway i can write this code efficiently and reduce runtime? I am trying to import data from multiple files in a folder

clc;clear;

testfiledir = 'C:\Users\bidgu\OneDrive\Desktop\manpower';
matfiles = dir(fullfile(testfiledir, '*.xlsm'));
nfiles = length(matfiles);
datafi  = cell(nfiles);
for i = 1 :nfiles
%    fid = fopen( fullfile(testfiledir, matfiles(i).name) );
   datafi{i} = readtable(fullfile(testfiledir, matfiles(i).name));
%    fclose(fid);
end

6 个评论
显示 4更早的评论隐藏 4更早的评论

dpb 2020-1-18

"I need the data from all those files at a time and to do anaysis on it"

Then go back to the suggestion I made earlier -- and perhaps Walter's could possibly help some -- and read the files as data; put together and then make a table (or not; depending upon the analyses desired, the array form may be more efficient).

As noted also, it's not possible to help much w/o example of the file(s) and some more specific idea of what it is that is the end result desired (beyond reading them all). Attach sample file if expect anybody to be able to do anything other than simply pontificate.

Prajwal Venkatesh 2020-1-18

what command should i use to read it as any other format of data and then to concatenate it?

请先登录，再进行评论。

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

采纳的回答

J. Alex Lee 2020-1-18

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/500800-this-code-is-taking-a-lot-of-time-to-run#answer_410769

If all the files have the same format, I have seen big improvements using detectImportOptions() on the first file re-use those options for all subsequent ones (expecially if the excel files are formatted oddly):

https://www.mathworks.com/help/matlab/import_export/importing-tabular-data-into-a-matlab-table-with-customized-options.html

This is a cumbersome solution, but if you really need speed and will re-use a lot, may be worth it to interact directly with the Excel com server object, which in my experience is much faster to read and write data (at least within a single file).

https://www.mathworks.com/help/matlab/matlab_external/example-reading-excel-spreadsheet-data.html