string in excel file

2022 6 20
1 个回答
更新时间：2022 6 21
3 次查看（30 天）

0 个投票

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

0 个投票

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

4 个评论
显示 2更早的评论 隐藏 2更早的评论

Davindra Usov
Davindra Usov 2022-6-21
Thank you for your reply. My table is a 30x300 table full of strings/chars. I tried to use: contains(g,'LATITUDES'), where g is the table but I get this error: Error using contains
Search term must be a text or pattern array.
I thought my search term is already text?
Image Analyst
Image Analyst 2022-6-21
The search term is a string but g is a table.
If you have any more questions, then attach your data and code to read it in with the paperclip icon after you read this:
TUTORIAL: How to ask a question (on Answers) and get a fast answer
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

请先登录，再进行评论。

类别

在 帮助中心 和 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