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!