How can I write excel file in MatLab

1 次查看（过去 30 天）
Chandan Mahishi
Chandan Mahishi 2015-7-15
评论： Chandan Mahishi 2015-7-15
I have huge number of excel files. I have to collect certain data from each of the files and write all of them in a single excel file. How can I do it?

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

回答（1 个）

Durgesh Naik
Durgesh Naik 2015-7-15
filename = 'Book1_Test.xlsx'; A = {1 2 3 5 6 6 2 0.222 0.122 0.444}; B = {1 12 13 15 1 61 21}; sheet = 1; n = xlsread('Book1_Test.xlsx'); e = length(n); e = mat2str(e) xlRange = (['A' e+1])
xlswrite(filename,A',sheet,xlRange)
  1 个评论
Chandan Mahishi
Chandan Mahishi 2015-7-15
I want to collect data of power, current and efficiency. I have all those data in different files and want them in single excel file with one heading.

请先登录，再进行评论。

类别

在 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