How concatenate all the excel filles in one table in MATLAB

2 次查看（过去 30 天）

显示更早的评论

Ayman Mounir 2020-12-11

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/690570-how-concatenate-all-the-excel-filles-in-one-table-in-matlab

评论： Ayman Mounir 2020-12-11

采纳的回答： Mathieu NOE

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 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

采纳的回答

Mathieu NOE 2020-12-11

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/690570-how-concatenate-all-the-excel-filles-in-one-table-in-matlab#answer_572200

在 MATLAB Online 中打开

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

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Ayman Mounir 2020-12-11

Thanks :D

请先登录，再进行评论。

类别

MATLAB Data Import and Analysis Data Import and Export Standard File Formats Spreadsheets

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

产品

MATLAB

版本

R2020b

Community Treasure Hunt

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

Start Hunting!

Translated by