MATLAB: How concatenate all the excel filles in one table in MATLAB

concatenate excelMATLAB

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

Best Answer

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
Related Question