Searching particular string in an excel spreadsheet

Question

Ghenji 2018-4-6

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/393084-searching-particular-string-in-an-excel-spreadsheet

编辑： 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?

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Ghenji 2018-4-9

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/393084-searching-particular-string-in-an-excel-spreadsheet#answer_314197

编辑：Ghenji 2018-4-9

在 MATLAB Online 中打开

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

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

Answer 2

Image Analyst 2018-4-6

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/393084-searching-particular-string-in-an-excel-spreadsheet#answer_313779

How about hauling it into MATLAB with xlsread() and search each cell for the string with strfind()?

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

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.

请先登录，再进行评论。