increment row in excel from matlab script

3 Ansichten (letzte 30 Tage)
Deepan Muthusamy
Deepan Muthusamy am 7 Jul. 2021
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 Kommentare
Image Analyst
Image Analyst am 7 Jul. 2021
Are you saying you want a 1x5 vector of numbers to all be inside a single cell of the spreadsheet?
Deepan Muthusamy
Deepan Muthusamy am 7 Jul. 2021
i want 1x5 in 5 cells and this pattern should repeat for 256 times

Melden Sie sich an, um zu kommentieren.

Akzeptierte Antwort

Johannes Hougaard
Johannes Hougaard am 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");

Weitere Antworten (0)

Produkte


Version

R2019a

Community Treasure Hunt

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

Start Hunting!

Translated by