MATLAB: Reading excel files in a directory

xlsread

I have many excel files (.xlsx format) in a directory with names R1,R2,R3….R89. Is it possible to read them one by one to execute certain commands and save them back without having to do it manually?

Best Answer

Something like this:
for k=1:89
FileName=['R',num2str(k)];
data=xlsread([FileName,'.xlsx']);
% do stuff on data
xlswrite([FileName,'_Output.xlsx'],data);
end
Related Question