How concatenate all the excel filles in one table in MATLAB
2 visualizzazioni (ultimi 30 giorni)
Mostra commenti meno recenti
Ayman Mounir
il 11 Dic 2020
Commentato: Ayman Mounir
il 11 Dic 2020
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
0 Commenti
Risposta accettata
Mathieu NOE
il 11 Dic 2020
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
Più risposte (0)
Vedere anche
Categorie
Scopri di più su Spreadsheets in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!