increment row in excel from matlab script

5 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)

Kategorien

Mehr zu Data Import from MATLAB finden Sie in Help Center und File Exchange

Produkte


Version

R2019a

Community Treasure Hunt

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

Start Hunting!

Translated by