清空筛选条件
清空筛选条件

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

3 次查看（过去 30 天）
James Boyle
James Boyle 2017-8-1
评论： James Boyle 2017-8-1
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)

请先登录，再回答此问题。

采纳的回答

Ganesh Hegade
Ganesh Hegade 2017-8-1
You can get the index below way.
[~,txt,~] = xlsread('Filename');
[row,col] = find(cellfun('length',regexp(txt,'31.5 Hz')) == 1);

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by