Find a particular value in an Excel sheet (Activex or xlsread?)

1 visualización (últimos 30 días)
I'm looking for a way to find the location of a specific element inside an Excel sheet, for example, I need my code to search the sheet for '31.5 Hz' and then output that this is found in cell J27, or wherever. I can't seem to find a simple way of doing this. Any help appreciated! (Windows 10, R2016a)

Respuesta aceptada

Ganesh Hegade
Ganesh Hegade el 1 de Ag. de 2017
You can get the index below way.
[~,txt,~] = xlsread('Filename');
[row,col] = find(cellfun('length',regexp(txt,'31.5 Hz')) == 1);
  1 comentario
James Boyle
James Boyle el 1 de Ag. de 2017
Thanks, I ended up coming up with a long winded method to do it, but this is much faster.

Iniciar sesión para comentar.

Más respuestas (0)

Community Treasure Hunt

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

Start Hunting!

Translated by