Using looping and change in xlrange and xlsread

2 次查看（过去 30 天）
androidguy
androidguy 2017-2-22
评论： androidguy 2017-2-22
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 -
https://www.mathworks.com/matlabcentral/fileexchange/15748-excel-column-number-to-column-name/content/xlsColNum2Str.m
I would appreciate any help in solving this problem.
Thank you,
  2 个评论
Jan
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
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.
  1 个评论
androidguy
androidguy 2017-2-22
Apologies for bumping my question. But anyway, I took your advise and simply imported my data into a matrix rather than using xlsread every iteration. It's much faster that way. Thanks Jan Simon.

请先登录，再进行评论。

更多回答（0 个）

类别

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

标签

产品

Community Treasure Hunt

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

Start Hunting!

Translated by