How concatenate all the excel filles in one table in MATLAB

I have many excel files in a folder, I want to concatenate them in one table in MATLAB.

Hint: if i am going to use vercat( readtable('file_name') ); i have to write all the files names this is the issue.

Thanks in advacne

Answer 1

[Mathieu NOE]

hi

this is an example

folder   = cd;  
folderout = [cd '\out']; 
Files = dir(fullfile(folder, '*.xlsx'));  % Use absolute path names

for ci = 1:length(Files);
    data_file = readmatrix(Files(ci).name,'NumHeaderLines',15);
    
end

[Ayman Mounir]

Thanks :D