For loop for read xls
1 Ansicht (letzte 30 Tage)
Ältere Kommentare anzeigen
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.
0 Kommentare
Antworten (1)
KSSV
am 3 Jul. 2022
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
0 Kommentare
Siehe auch
Kategorien
Mehr zu Debugging and Analysis finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!