Blank files need to be skipped

Question

Franchesca 2014-5-13

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/129500-blank-files-need-to-be-skipped

回答： Image Analyst 2014-5-13

%%Import data 
numfiles = 54; % number of excel files 
mydata=cell(numfiles,1); % defining size of mydata
grouped = xlsread('Group B File Info');
d=dir('Trial*.csv');
for i=1:length(mydata) % loop to import mutliple excel files 
if d(i).bytes>10
  mydata{i} = xlsread(d(i).name); % import files into mydata
else
  disp([d(i).name 'read failed'])
end
myfilename = sprintf('Trial%02d.csv', i); % define file name 
mydata{i} = xlsread(myfilename); % import files into mydata

That is my code and this is the error I am recieving:

Error using xlsread (line 247)
File C:\Users\Caz\Documents\MATLAB\coursework\Trial06.CSV not in Microsoft Excel Format.

Error in MatlabCoursework (line 23) mydata{i} = xlsread(myfilename); % import files into mydata

Trial06.CSV is in the folder in the same format as all the other trials, however it is blank which is why the if, else was added incase of a blank file.

How do I overcome this?