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.