Read thousands of xls file from a folder fast.

Question

Razvan Inte 2019-10-29

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/488072-read-thousands-of-xls-file-from-a-folder-fast

评论： Walter Roberson 2019-11-12

Hello,

I have to read 20k or more xls files from a folder. From the xls I need just the values from between C26 and C29, this values are used after in some calculations.

So far i have this script:

clc, close, clear all
    folder ='Folder adress';
    filetype = '*.xls';
    f=fullfile(folder,filetype);
    d=dir(f);
              
for k=1:numel(d);                           
        data{k}= xlsread(fullfile(folder,d(k).name),'C27:C29');
        a=data{1,k};  
if size(a) == [0,0] 
            b(k) = 0;
            x(k) = 0;
else 
        b(k)=a(3,1)/a(1,1);
        x(k)=(b(k)-1)/(b(k)+1);
      end
   end    

It take the script about 30 minuters up to an hour to read all the excel files.Sometime the excel applicaion crash during the process.

There is another method to do this faster?

How can I stop excel from crashing (stop working)?

Thank you!

3 个评论
显示 1更早的评论隐藏 1更早的评论

Razvan Inte 2019-10-30

The problem is not necessary the time. But I read somewhere that there is another way to import data from excel, by open excel just once throug the entire duration of the process. Anyway the main problem is that during the import process the excel stop working.