storing excel data in matrix using for loop

2 次查看（过去 30 天）
Davindra Usov
Davindra Usov 2022-5-16
评论： Davindra Usov 2022-6-20
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

请先登录，再回答此问题。

采纳的回答

Stephen23
Stephen23 2022-5-16
编辑：Stephen23 2022-5-16
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

更多回答（0 个）

类别

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

标签

产品


版本

R2021b

Community Treasure Hunt

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

Start Hunting!

Translated by