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

12 views (last 30 days)
정우 제
정우 제 on 14 Sep 2021
Answered: Prince Kumar on 24 Nov 2021
many cvs files 9, 10(or J, K) matrix read in matlab ->many variable calculate -> input one excel file
  1 Comment
源樹 上林
源樹 上林 on 14 Sep 2021
How about this way ?
a = xlsread('hogehoge.csv');
b = xlsread('fugafuga.csv');
filename = 'piyopiyo.xlsx';
xlswrite(filename, a, 'sheet1');
xlswrite(filename, b, 'sheet2');

Sign in to comment.

Answers (1)

Prince Kumar
Prince Kumar on 24 Nov 2021
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.

Community Treasure Hunt

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

Start Hunting!

Translated by