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

13 次查看（过去 30 天）
정우 제
정우 제 2021-9-14
回答： Prince Kumar 2021-11-24
many cvs files 9, 10(or J, K) matrix read in matlab ->many variable calculate -> input one excel file
  1 个评论
源樹 上林
源樹 上林 2021-9-14
How about this way ?
a = xlsread('hogehoge.csv');
b = xlsread('fugafuga.csv');
filename = 'piyopiyo.xlsx';
xlswrite(filename, a, 'sheet1');
xlswrite(filename, b, 'sheet2');

请先登录，再进行评论。

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

回答（1 个）

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

类别

在 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