Reading excel files in a directory

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?

Answer 1

[Fangjun Jiang]

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