How do I use a for loop with excel
显示 更早的评论
I am making a for loop that draws in excel and I cannot get the right syntax to change the row given the iteration constant "z". My for loop works when I have for example: 'B5:D5', but when i want to incorporate the iteration constant it does not work. Help please
height = 5
for z = 1:18
if height == z
s= xlsread('myexcelfile','sheet','Bz:Bz')
....the rest of the loop works fine,
采纳的回答
Andrei Bobrov
2013-3-11
height = 5
for z = 1:18
if height == z
s= xlsread('myexcelfile','sheet',sprintf('B%d',z));
end
...
end
2 个评论
carl chew
2013-3-11
Andrei Bobrov
2013-3-11
height = 5
for z = 1:18
if height == z
s= xlsread('myexcelfile','sheet',sprintf('B%d:D%d',z,z));
end
...
end
更多回答（0 个）
类别
在 帮助中心 和 File Exchange 中查找有关 Loops and Conditional Statements 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
