Using the text from the excel data imported

3 次查看（过去 30 天）
Mark
Mark 2013-3-16
I imported an Excel file with text. I named this data data_with_text. When I use
>> word1=data_with_text(1,1)
I get:
word1 = 'ABC'
Ideally I could run something like this using word1:
>> if word1=='ABC'
x=1
else
x=0
end
However, this does not work and I get this error,
Undefined function 'eq' for input arguments of type 'cell'.
which I presume comes from the apostrophes because word1='ABC' and not plain ABC without the apostophes
Is there any way around this?

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

采纳的回答

Image Analyst
Image Analyst 2013-3-16
It's a cell. Try converting it to a character string:
word1 = char(data_with_text(1,1))
Or maybe you could do it this way too:
word1=data_with_text{1,1} % {} mean "contents of the cell"

更多回答（1 个）

Azzi Abdelmalek
Azzi Abdelmalek 2013-3-16
Use
if strcmp(word1,'ABC')

类别

在 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