How to import many csv files in matlab and export one excel file?

many cvs files 9, 10(or J, K) matrix read in matlab ->many variable calculate -> input one excel file

[源樹 上林]

How about this way ?

a = xlsread('hogehoge.csv');
b = xlsread('fugafuga.csv');
filename = 'piyopiyo.xlsx';
xlswrite(filename, a, 'sheet1');
xlswrite(filename, b, 'sheet2');

Answer 1

[Prince Kumar]

Hi,

You can use readtable function to read the csv files and combine them into a single excel file.

t1 = readtable('data1.csv');
t2 = readtable('data2.csv');

writetable(t1,'myData.xls','Sheet',1);
writetable(t2,'myData.xls','Sheet',2);

Here, content of 'data1.csv' and 'data2.csv' is being writtent to sheet 1 and 2 of the excel sheet respectively.