string in excel file

1 次查看（过去 30 天）
Davindra Usov
Davindra Usov 2022-6-20
评论： 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
Image Analyst 2022-6-21
Not sure why you can't use ismember. Did you try readcell, strfind, and contains?
  4 个评论
显示 2更早的评论
Davindra Usov
Davindra Usov 2022-6-21
Hi,
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
Davindra Usov 2022-6-21
Also, thank you very much for your response

请先登录，再进行评论。

类别

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

标签

产品


版本

R2021b

Community Treasure Hunt

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

Start Hunting!

Translated by