Searching particular string in an excel spreadsheet

4 次查看（过去 30 天）
Ghenji
Ghenji 2018-4-6
编辑： Ghenji 2018-4-9
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?

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

采纳的回答

Ghenji
Ghenji 2018-4-9
编辑：Ghenji 2018-4-9
This worked for me.
Range.Find('String', [], [], 1)
Since the position for LookAt is 4th and I need xlWhole. xlWhole = 1; xlPart = 2;
Referring to this documentation https://msdn.microsoft.com/en-us/vba/excel-vba/articles/range-find-method-excel

更多回答（1 个）

Image Analyst
Image Analyst 2018-4-6
How about hauling it into MATLAB with xlsread() and search each cell for the string with strfind()?
  1 个评论
Ghenji
Ghenji 2018-4-6
well am loading all the the parameters using excel.application. Going back to xlsread() would be long road and further even after using strfind() i will have to move back to to excel.application since I want read the data labelled with some color.

请先登录，再进行评论。

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by