How to select and write values from data into excel

2017 2 23
1 个回答
回答已采纳
更新时间：2017 2 26
15 次查看（30 天）

0 个投票

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

1 个投票

x = rand(98820, 1);
y = reshape(x, 4941, 20);
xlswrite(FileName, y);

3 个评论
显示 1更早的评论 隐藏 1更早的评论

John BG
John BG 2017-2-25
what if 98829/4941 is not integer? then this doesn't work.
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.
Arslan F
Arslan F 2017-2-26
98820/4941 is an integer its 20 (its not 98829)

请先登录，再进行评论。

更多回答（0 个）

类别

在 帮助中心 和 File Exchange 中查找有关 Data Import from MATLAB 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by