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 个)

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 的更多信息

回答:

2021-5-18

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by