MATLAB: Square Matrix

excelMATLABmatrix

i have a very simple quetion. Say , a Matrix (5×1)named A.
A= [ 2;2;2;2;2 ]
How I can make a square matrix (5×5) with all 2 contained from command window taking the A from an excel file ?

Best Answer

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