How to force a for loop to continue?

10 views (last 30 days)
Elaheh
Elaheh on 2 Aug 2018
Edited: Jan on 27 Jun 2019
Hi, I need to copy data from individual excel files from 33 participants, and paste all in one excel file. I did it for the first sheet and then for the second sheet, etc. The problem is that some of the files have 4 sheets and some have 6 sheets. Also, some of the sheets do not have data. Therefore the script stops when there is no data. How can I force it to continue and report the missing data? The following stops when data doesn't exist.
first_data = true;
for i=2:34
sheet=6;
STIMroot='C:\Users\ski\CloudStation\Zahra\dissertation\data analysis\behavioral data analysis\monolingualSTIM\';
Drop='C:\Users\ski\CloudStation\Zahra\dissertation\data analysis\behavioral data analysis\monolingualSTIM\final.xls';
STIMfile=strcat(STIMroot,num2str(i),'\',num2str(i),'.xls'); %get the STIM file
if exist(STIMfile,'file')
STIMdata = xlsread( STIMfile,sheet);
data2=STIMdata(:,3:5);
if first_data == true;
export_data = data2;
first_data = false;
else
export_data = horzcat(export_data,data2 );
end
else
warningMessage = sprintf('Warning: file does not exist:\n%s',h);
continue;
end
end
xlswrite(Drop,export_data,1);

Accepted Answer

OCDER
OCDER on 2 Aug 2018
Use try/catch statements to force a loop to continue due to an unexpected error.
for j = 1:10
try
... your code...
catch
warning('found error in %dth file', j);
continue
end
... your code, if "try" codes succeed
end
  3 Comments
Jan
Jan on 27 Jun 2019
Edited: Jan on 27 Jun 2019
Some programmers avoid continue for reasons of clarity. The code can be written without it also:
for j = 1:10
try
... your code...
... your code, if "try" codes succeed
catch ME
warning('found error in %dth file: %s', j, ME.message);
end
end

Sign in to comment.

More Answers (0)

Categories

Find more on Software Development Tools in Help Center and File Exchange

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by