How can I merge Excel files into only one file in Matlab?

Now I got 24 excel file in csv format , i would like to use matlab to combine all the csv files into one file , i would like to have a script to perform this .

Many thanks , Alex

Answer 1

[Michael Haderlein]

files=dir('input*.csv');
output='out.csv';
fidout=fopen(output,'w');
for cnt=files'
  fidin=fopen(cnt.name);
  fwrite(fidout,fread(fidin));
  fprintf(fidout,'\n');
  fclose(fidin);
end
fclose(fidout);

[NG]

i have tried to use these scripts in matlab, but i cannot merge the two excel file into one. Matlab just created a new csv file .

[Michael Haderlein]

Actually, in my opinion it's the better solution to merge everything in a new file. However, if you want to merge everything in the first file, you can do that by

files=dir('input*.csv')';
fidout=fopen(files(1).name,'a');
for cnt=files(2:end)
  fidin=fopen(cnt.name);
  fwrite(fidout,fread(fidin));
  fclose(fidin);
end
fclose(fidout);