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

 Réponse acceptée

Matt Tearle
Matt Tearle le 23 Mar 2011

0 votes

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

Plus de réponses (0)

Catégories

Tags

Community Treasure Hunt

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

Start Hunting!

Translated by