Square Matrix

2 次查看（过去 30 天）

Chaklader Asfak 2011-8-18

i have a very simple quetion. Say , a Matrix (5x1)named A.

A= [ 2;2;2;2;2 ]

How I can make a square matrix (5x5) with all 2 contained from command window taking the A from an excel file ?

Oleg Komarov 2011-8-18

If you want to take a vector from excel and replicate it such that the result is a square matrix, then:

a = xlsread('myfile.xlsx');
a = repmat(a(:),1,numel(a));

Chaklader Asfak 2011-8-18

thanks :)

MATLAB Data Import and Analysis Data Import and Export Standard File Formats Spreadsheets

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

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

Translated by