merge multiple excel file data

11 views (last 30 days)
Sara Ejaz
Sara Ejaz on 19 Mar 2023
Commented: Mathieu NOE on 6 Apr 2023
hello..
i store image data into excel file with the size of 786432x1
first file name is 1.csv second file is save as 2.csv upto 500 hundred files each file contain 786432x1 record
know a want to merge all these files in such a way that if first file end an 786432 row then second file record start at 786433 to 1572864
3rd image recored start at 1572865 and upto soo on
all 500 picture are in store in single file with one column

Answers (1)

Mathieu NOE
Mathieu NOE on 20 Mar 2023
Edited: Mathieu NOE on 20 Mar 2023
hello
try this
to make sure to get the files in the right ordre please download first this submission
(dir is not 100% reliable)
P = pwd; % get working directory (or specify it)
S = dir(fullfile(P, '*.csv'));
S = natsortfiles(S); % sort folders / file names into order
% https://fr.mathworks.com/matlabcentral/fileexchange/47434-natural-order-filename-sort
data_all = [];
for k = 1:numel(S)
F = fullfile(S(k).folder, S(k).name);
data = readmatrix(F); % or READTABLE or csvimport or whatever.
data_all = [data_all; data(:)];
end

Community Treasure Hunt

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

Start Hunting!