string in excel file

1 次查看（过去 30 天）

Davindra Usov 2022-6-20

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1744480-string-in-excel-file

评论： Davindra Usov 2022-6-21

Hi,

How can I find out if a certain word, e.g. 'oranges' is contained within an excel sheet? I can't use ismember as for some reason, the string has to be stored in a vector.

Thanks :)

回答（1 个）

Image Analyst 2022-6-21

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1744480-string-in-excel-file#answer_989865

Not sure why you can't use ismember. Did you try readcell, strfind, and contains?

So i've managed to fix it my converting the table to an array. Then used 'find' to locate the indices. However, I'm now stuck on using readtable to read in an excel file with multiple sheets. I can't attach my code as it's confidental. The amount of info I've given is what's allowed but I can't send the code itself :(

Davindra Usov 2022-6-21