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,

 采纳的回答

height = 5
for z = 1:18
if height == z
s= xlsread('myexcelfile','sheet',sprintf('B%d',z));
end
...
end

2 个评论

sorry i meant 'Bz:Dz'
how would i write that?
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