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!