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!

 Réponse acceptée

Walter Roberson
Walter Roberson le 28 Mar 2016
bw_idx = find( ~cellfun(@isempty, strfind(sheets, 'BW')) );

Plus de réponses (0)

Catégories

En savoir plus sur Characters and Strings dans Centre d'aide et File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by