how to automatically find the location of the element/text in excel

9 次查看（过去 30 天）
Aiman Zara
Aiman Zara 2023-4-6
回答： Mathieu NOE 2023-4-6
I have to find a specific position/ location of any element in excel how would I do that? Like If I have to find the position of laptop from the table, then how to do that without even mentioning its row no or column number. I want it to be like: I name it (fan ) and it shows me its exact position. Also if that name resides in more than one location then it should also show those locations too.

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

回答（1 个）

Mathieu NOE
Mathieu NOE 2023-4-6
hello
here you are :
T = readcell('example.xlsx');
% T = 6×3 cell array
% {'Stage'} {'health' } {'Object'}
% {[ 1]} {'good' } {'chair' }
% {[ 2]} {'good' } {'table' }
% {[ 3]} {'bad' } {'fan' }
% {[ 4]} {'average'} {'bag' }
% {[ 5]} {'average'} {'laptop'}
[r,c] = find(strcmp(T,'fan')); % row and col position of 'fan' in T cell array
r = r -1; % do this if the header line ({'Stage'} {'health' } {'Object'}) must not be taken into account

类别

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

标签

产品


版本

R2019a

Community Treasure Hunt

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

Start Hunting!

Translated by