How do I use a for loop with excel
1 view (last 30 days)
Show older comments
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,
0 Comments
Accepted Answer
Andrei Bobrov
on 11 Mar 2013
height = 5
for z = 1:18
if height == z
s= xlsread('myexcelfile','sheet',sprintf('B%d',z));
end
...
end
2 Comments
Andrei Bobrov
on 11 Mar 2013
height = 5
for z = 1:18
if height == z
s= xlsread('myexcelfile','sheet',sprintf('B%d:D%d',z,z));
end
...
end
More Answers (0)
See Also
Categories
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!