assess the xlread in elsefi command

1 view (last 30 days)
Nabeel
Nabeel on 16 Mar 2015
Answered: Jan on 16 Mar 2015
xlread is used to read xls files i want to use this command in ifelse condiations
if input==a
B=AS
elseif
B=AQ
it means that xlread the column AS
how i generate the code for above algorithm
columnB = xlsread(filename,'B:B')
[EDITED, Jan, please format the code properly, thanks]

Accepted Answer

Jan
Jan on 16 Mar 2015
if strcmp(in, 'a')
B = 'AS';
else % not elseif
B = 'AQ';
end
columnB = xlsread(filename, [B, ':', B]);

More Answers (0)

Categories

Find more on Data Import and Analysis in Help Center and File Exchange

Community Treasure Hunt

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

Start Hunting!