Import worksheet in excel

Hi all, I have a little problem. I have a file in Excel and import to Matlab:
lab= {'9.4', '9.2_1','9.2_2','9.2_3','9.2_4','9.2_5','8.1','8.2_1','8.2_2'};
K = length(lab);
for c = 1:K
[ndata, text, alldata] = xlsread('test.xls',lab{c});
end
I don't know how I solve the problem when in Excel is not sheet (eg. '8.2_1')
Thank you

 Risposta accettata

Matt Tearle
Matt Tearle il 23 Mar 2011
[~,sheets] = xlsfinfo('test.xls')
Then compare sheets to lab using set operations (eg ismember or intersect)

Più risposte (0)

Categorie

Community Treasure Hunt

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

Start Hunting!

Translated by