how to Read and process multiple rows from Excel
显示 更早的评论
I have 4 spreadsheets with about 20 rows. I'm trying to take the data from the same row in each spreadsheet and process it like so: A1 = xlsread(filename,'cluster','A1:AD1'); A2 = xlsread(filename,'Variance','A1:AD1'); ....... How can I make a loop that increases the row number each time it runs? I tried this code but it gives an error
for i=1:20
xlRange = 'A',i,':AD',i
A1 = xlsread(filename,'cluster', xlRange);
A2 = xlsread(filename,'Variance', xlRange);
end
采纳的回答
A loop solution (although I prefer the 2nd suggestion below). Here we define the range dynamically using sprintf().
Written on the fly; not tested...
nrows = 20;
for i = 1:nrows
xlrange = sprintf('A%d:I%d', i, i);
A1 = xlsread(filename,'cluster', xlrange )
A2 = xlsread(filename,'Variance', xlrange )
end
Instead, why not just read from all of the needed rows at the same time? Non-loop solution:
Written on the fly; not tested...
A1 = xlsread(filename,'cluster', 'A1:I5');
A2 = xlsread(filename,'Variance', 'A1:I5');
更多回答（0 个）
类别
在 帮助中心 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Translated by 
