load files automatically and combine
1 次查看(过去 30 天)
显示 更早的评论
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 个评论
采纳的回答
KSSV
2019-4-5
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')
更多回答(0 个)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Dates and Time 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!