storing excel data in matrix using for loop

Hi,

I have a 4x20 matrix, A, that I have first initialised using zeros(4,20). For each row in this matrix, I want to store a 1x20 vector of data from excel. The values in these 1x20 vectors differ for each of the 4 rows (for each row, a 1x20 vector is exported from a different excel sheet). This is what I have tried so far but it is not working, as I get the error: "Unable to perform assignment because the left and right sides have a different number of elements.":

A=zeros(4,20);

n=4;

for y=1:n

A(y)=readmatrix('filename', 'Sheet', ['sheetname_' num2str(y)], 'Range', 'C5:V5');

end

Thank you

Answer 1

[Stephen23]

n = 4;
A = zeros(n,20);
F = 'filename.xyz';
for y = 1:n
    S = sprintf('sheetname_%d',y);
    A(y,:) = readmatrix(F, 'Sheet', S, 'Range', 'C5:V5');
end %  ^^ indexing

https://www.mathworks.com/help/matlab/learn_matlab/array-indexing.html

[Davindra Usov]

Thank you!!