Read from excel and compare text

2 次查看（过去 30 天）
Sajid Afaque
Sajid Afaque 2019-3-21
评论： Sajid Afaque 2019-3-21
I need to read a column from excel for example say I need to read user_id column from excel and the excel sheet is present in some other folder at desktop.after I read the column containing user_id's I need to search for a particular user_id. How do I do that ...?

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

采纳的回答

Walter Roberson
Walter Roberson 2019-3-21
readtable() to get the data into place. strcmp() or ismember() the appropriate column of the table.
  3 个评论
显示 1更早的评论
Walter Roberson
Walter Roberson 2019-3-21
If the user_id are numeric:
specific_user_id == YourTable.user_id
If the user_id are character vectors:
strcmp(specific_user_id, YourTable.user_id)
If you just need to know whether the specific ID is found at all:
ismember(specific_user_id, YourTable.user_id)
If you need to know whether it is found and where it was found and there is only at most one match:
[specific_was_found, idx] = ismember(specific_user_id, YourTable.user_id);

请先登录，再进行评论。

更多回答（0 个）

类别

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

标签

产品


版本

R2013b

Community Treasure Hunt

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

Start Hunting!

Translated by