Azzera filtri
Azzera filtri

Using looping and change in xlrange and xlsread

7 visualizzazioni (ultimi 30 giorni)
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 Commenti
androidguy
androidguy il 22 Feb 2017
Just bumping this question to get noticed.
Jan
Jan il 22 Feb 2017
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.

Accedi per commentare.

Risposta accettata

Jan
Jan il 22 Feb 2017
Modificato: Jan il 22 Feb 2017
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 Commento
androidguy
androidguy il 22 Feb 2017
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.

Accedi per commentare.

Più risposte (0)

Prodotti

Community Treasure Hunt

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

Start Hunting!

Translated by