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!

 Respuesta aceptada

Walter Roberson
Walter Roberson el 28 de Mzo. de 2016
bw_idx = find( ~cellfun(@isempty, strfind(sheets, 'BW')) );

Más respuestas (0)

Categorías

Más información sobre Characters and Strings en Centro de ayuda y File Exchange.

Preguntada:

el 28 de Mzo. de 2016

Comentada:

el 28 de Mzo. de 2016

Community Treasure Hunt

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

Start Hunting!

Translated by