increment row in excel from matlab script

i want a matrix [1x5], i want to write this into an excel sheet in the following pattern,
the [1x5] should repeat 256 times in the row and also should repeat 256 times in column.
Basically i want a [256x256] matrix of [1x5] matrix. i dont know how to increment the row row and column number.

2 个评论

Are you saying you want a 1x5 vector of numbers to all be inside a single cell of the spreadsheet?
i want 1x5 in 5 cells and this pattern should repeat for 256 times

请先登录,再进行评论。

 采纳的回答

I think the easiest would be to keep your matrix in MATLAB and make the large matrix in MATLAB before writing the Excel sheet.
the_matrix = randn(1,5);
the_pattern = repmat(the_matrix,256,256);
writematrix(the_pattern,"thisisanexcelfile.xlsx");

更多回答(0 个)

类别

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

产品

版本

R2019a

标签

Community Treasure Hunt

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

Start Hunting!

Translated by