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!