Merging multiple file excel
조회 수: 4 (최근 30일)
이전 댓글 표시
Hi, I have 1000 file excel with only two field in column: time and value.
I would like to merge in one excel file with only two columns.
There is something solution?
댓글 수: 0
채택된 답변
Mathieu NOE
2021년 9월 21일
hello Rachele
you can do this -
I used natsortfile (from FEX : https://fr.mathworks.com/matlabcentral/fileexchange/47434-natural-order-filename-sort ) to make sure the data are grabbed from the files in their natural name sorting which is not what matlab does autmatically
clc
clearvars
fileDir = pwd;
outfile = 'OUT.xlsx'; % output file name
fileNames = dir(fullfile(fileDir,'data*.xlsx')); % get list of data files in directory
fileNames_sorted = natsortfiles({fileNames.name}); % sort file names into order (https://fr.mathworks.com/matlabcentral/fileexchange/47434-natural-order-filename-sort)
M= length (fileNames_sorted);
out_data = [];
for f = 1:M
% option # 1 for numeric data only using importdata
raw = importdata( fullfile(fileDir, fileNames_sorted{f}));
% vertical contatenation of all individual files data
out_data = [out_data; raw.data];
end
% store out_data in excel file
writematrix(out_data,fullfile(fileDir,outfile));
추가 답변 (1개)
참고 항목
카테고리
Help Center 및 File Exchange에서 Spreadsheets에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!