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

 Accepted Answer

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

More Answers (0)

Categories

Tags

Community Treasure Hunt

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

Start Hunting!