increment row in excel from matlab script

13 views (last 30 days)
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 Comments
Deepan Muthusamy
Deepan Muthusamy on 7 Jul 2021
i want 1x5 in 5 cells and this pattern should repeat for 256 times

Sign in to comment.

Accepted Answer

Johannes Hougaard
Johannes Hougaard on 7 Jul 2021
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");

More Answers (0)

Products


Release

R2019a

Community Treasure Hunt

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

Start Hunting!

Translated by