increment row in excel from matlab script
4 views (last 30 days)
Show older comments
Deepan Muthusamy
on 7 Jul 2021
Answered: Johannes Hougaard
on 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 Comments
Image Analyst
on 7 Jul 2021
Are you saying you want a 1x5 vector of numbers to all be inside a single cell of the spreadsheet?
Accepted Answer
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");
0 Comments
More Answers (0)
See Also
Categories
Find more on Data Import from MATLAB in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!