how to automatically find the location of the element/text in excel
3 ビュー (過去 30 日間)
古いコメントを表示
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.
0 件のコメント
回答 (1 件)
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
0 件のコメント
参考
カテゴリ
Help Center および File Exchange で Data Import from MATLAB についてさらに検索
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!