Reading multiple excel files in sequence
显示 更早的评论
Dear All,
How can i input multiple excel files in a sequence from a same source folder, for example I have day to day data files coming from a measurement system (01.01.2021, 02.01.2021, 03.01.2021.................) and now I want to input the daily excel files and perform certain calculation and plotings and continue the same process for the upcoming days in an automated process.
Best Regards,
Sarmad
回答(1 个)
KSSV
2021-5-18
excelFiles = dir('*.xlsx') ;
N = length(excelFiles) ;
for i = 1:N
thisFile = excelFiles(i).name ;
T = readtable(thisFile) ;
% do what you want
end
类别
在 帮助中心 和 File Exchange 中查找有关 Data Import from MATLAB 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!