Using looping and change in xlrange and xlsread

Question

androidguy 2017-2-22

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/326299-using-looping-and-change-in-xlrange-and-xlsread

评论： 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 个评论
显示无隐藏无

androidguy 2017-2-22

Just bumping this question to get noticed.

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.

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Jan 2017-2-22

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/326299-using-looping-and-change-in-xlrange-and-xlsread#answer_255886

编辑：Jan 2017-2-22

在 MATLAB Online 中打开

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 个评论
显示 -1更早的评论隐藏 -1更早的评论

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.

请先登录，再进行评论。