xlsinfo, string comparison, sheet names

I would like to use the xlsinfo function as follows:
[status,sheets] = xlsfinfo(strcat(files.in.dir,files.in.name))
The actual tabs I may have in my file may be named as '1_4G_BW0.2' or '40_3G_BW5'.
How do I easily check if any of the tab names contain 'BW' as part of their name?
Is there any quick way to check if an Excel sheet contains a specific sheet?
Thanks!

 Accepted Answer

bw_idx = find( ~cellfun(@isempty, strfind(sheets, 'BW')) );

More Answers (0)

Categories

Asked:

on 28 Mar 2016

Commented:

on 28 Mar 2016

Community Treasure Hunt

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

Start Hunting!