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

 採用された回答

Matt Tearle
Matt Tearle 2011 年 3 月 23 日

0 投票

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

その他の回答 (0 件)

カテゴリ

ヘルプ センター および File ExchangeData Import from MATLAB についてさらに検索

タグ

Community Treasure Hunt

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

Start Hunting!

Translated by