increment row in excel from matlab script

Question

Deepan Muthusamy 2021-7-7

回答： Johannes Hougaard 2021-7-7

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.

Image Analyst 2021-7-7

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

Answer 1

Johannes Hougaard 2021-7-7

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");