How concatenate all the excel filles in one table in MATLAB
2 ビュー (過去 30 日間)
古いコメントを表示
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 件のコメント
採用された回答
Mathieu NOE
2020 年 12 月 11 日
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
その他の回答 (0 件)
参考
カテゴリ
Help Center および File Exchange で Spreadsheets についてさらに検索
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!