How to select and write values from data into excel

2 次查看（过去 30 天）
Arslan F
Arslan F 2017-2-23
评论： Arslan F 2017-2-26
I have a single column of 98820 values i want to divide them into groups of 4941 and write them in separate columns in excel

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

采纳的回答

Jan
Jan 2017-2-23
x = rand(98820, 1);
y = reshape(x, 4941, 20);
xlswrite(FileName, y);
  3 个评论
显示 1更早的评论
Image Analyst
Image Analyst 2017-2-25
Correct (though this more general question wasn't asked). If the vector is not an integer multiple of the number in a group, then Arslan should choose a different group size or else re-think what he wants to do. For the stated numbers, this works.

请先登录，再进行评论。

更多回答（0 个）

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by