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.
回答（1 个）
KSSV
2022-7-3
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
类别
在 帮助中心 和 File Exchange 中查找有关 Loops and Conditional Statements 的更多信息
2022-7-3
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
