Merging multiple file excel

조회 수: 10 (최근 30일)
Rachele Franceschini
Rachele Franceschini 2021년 9월 21일
댓글: Mathieu NOE 2021년 9월 21일
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?

채택된 답변

Mathieu NOE
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));
  댓글 수: 2
Rachele Franceschini
Rachele Franceschini 2021년 9월 21일
Thank you!!!!
Mathieu NOE
Mathieu NOE 2021년 9월 21일
my pleasure !

댓글을 달려면 로그인하십시오.

추가 답변 (1개)

Mathieu NOE
Mathieu NOE 2021년 9월 21일

카테고리

Help CenterFile Exchange에서 Spreadsheets에 대해 자세히 알아보기

제품


릴리스

R2021a

Community Treasure Hunt

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

Start Hunting!

Translated by