Searching particular string in an excel spreadsheet
2 ビュー (過去 30 日間)
古いコメントを表示
What are the options other than 'Range.Find' to search for a string in a spreadsheet? Am using actxserver('Excel.Application'). 'Range.Find' does not help since it start to look from first letter of the string and stops there. For ex. am looking for a string 'Jimmy'. Find would look everything row by row starting with J. if it finds 'John' it shall stop right there. How to make it look for complete string?
0 件のコメント
採用された回答
その他の回答 (1 件)
Image Analyst
2018 年 4 月 6 日
How about hauling it into MATLAB with xlsread() and search each cell for the string with strfind()?
参考
カテゴリ
Help Center および File Exchange で Spreadsheets についてさらに検索
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!