Merging multiple file excel

10 visualizaciones (últimos 30 días)
Rachele Franceschini
Rachele Franceschini el 21 de Sept. de 2021
Comentada: Mathieu NOE el 21 de Sept. de 2021
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?

Respuesta aceptada

Mathieu NOE
Mathieu NOE el 21 de Sept. de 2021
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 comentarios
Rachele Franceschini
Rachele Franceschini el 21 de Sept. de 2021
Thank you!!!!
Mathieu NOE
Mathieu NOE el 21 de Sept. de 2021
my pleasure !

Iniciar sesión para comentar.

Más respuestas (1)

Mathieu NOE
Mathieu NOE el 21 de Sept. de 2021

Etiquetas

Productos


Versión

R2021a

Community Treasure Hunt

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

Start Hunting!

Translated by