How to select and write values from data into excel

1 次查看(过去 30 天)
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 个评论
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 个)

Community Treasure Hunt

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

Start Hunting!

Translated by