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

4 次查看（过去 30 天）
NG
NG 2014-8-15
评论： Michael Haderlein 2014-8-16
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

请先登录，再回答此问题。

回答（1 个）

Michael Haderlein
Michael Haderlein 2014-8-15
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);
  2 个评论
NG
NG 2014-8-15
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
Michael Haderlein 2014-8-16
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);

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by