load files automatically and combine

Question

Lieke Numan 2019-4-5

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/454603-load-files-automatically-and-combine

评论： Lieke Numan 2019-4-5

I have a lot of (about 100) short consequetive excel files with datestamps and data. I want to automatically load them in to matlab (all files in a specific folder), and them combine them into one file.

The name of the files is not changing with only a number, as it contains the timestamp of the first datapoint. So can I automatically load all files from a specific folder?

And how can I subsequently combine these files (or the date and data within this file) into one file?

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

KSSV 2019-4-5

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/454603-load-files-automatically-and-combine#answer_369202

在 MATLAB Online 中打开

YOu should try some thing like below. It should work, if any error let me know.

files = dir('*xlsx') ;
N = length(files) ; 
T = readtable(files(1).name)
for i = 2:N
    T1 = readtable(files(i).name)
    T = [T ; T1] ;
end
writetable(T,'test.xlsx')