how to Read and process multiple rows from Excel

3 次查看（过去 30 天）
kmla
kmla 2018-9-25
编辑： Adam Danz 2018-9-25
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

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

采纳的回答

Adam Danz
Adam Danz 2018-9-25
编辑：Adam Danz 2018-9-25
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 个）

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by