Using looping and change in xlrange and xlsread
4 次查看(过去 30 天)
显示 更早的评论
Hello everyone
I have a tricky question for you. I am having trouble using variables in xlrange while looping. I am trying to change the change the column every iteration by generating the corresponding column alphabet and read the entire column in excel. My code snippet is as follows :
h = 0:5:300;
for k = 1:length(h)
x = 'xlsColNum2Str';
avg_rd = round(xlsread(filename,'sheet1', [x(k) ':' x(k)] ));
% i have some more numerical operations being performed on the column obtained from above variable "avg_rd"
end
The function "xlsColNum2Str" is coming from the below url -
I would appreciate any help in solving this problem.
Thank you,
2 个评论
Jan
2017-2-22
Please do not bump your question. A missing answer is a strong indicator for too few information. Then bumping waste the time of the readers only. Note, that you forgot to mention the problem you want to solve.
采纳的回答
Jan
2017-2-22
编辑:Jan
2017-2-22
I guess that you do not want to create the string 'xlsColNum2Str', but to call the function with this name:
h = 0:5:300;
for k = 1:length(h)
range = xlsColNum2Str(k);
avg_rd = round(xlsread(filename, 'sheet1', [range ':' range]));
...
end
It would be faster to import all columns at once with a single xlsread call.
更多回答(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!