For loop for read xls

Hello. I have a set of data and the names of the files are as follows.

WIOT95_ROW_Apr12, WIOT96_ROW_Apr12, ... ,WIOT11_ROW_Apr12.

I would like to use for loop to read the file sequentially and create some variables for each year.

I used the following code and it didn't work.

for j = 95:99

raw(j) = readtable('WIOT(j)_ROW_Apr12','Sheet','WIOT_19(j)','Range','E7:BCI1441');

wiot(j) = table2array(raw(j));

end

I was wondering how I can create the codes to do this work.

Thank you.

Answer 1

[KSSV]

xlFiles = dir('*.xls') ; % give extension of your files
N = length(xlFiles) ; 
% loop for each file
for i = 1:N
    xlFile = XlFiles(i).name ;
    T = readtable(xlFile) ;   
    % Do what you want 
end