Using looping and change in xlrange and xlsread

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,

[androidguy]

Just bumping this question to get noticed.

[Jan]

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]

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.

[androidguy]

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.