retrieving data from excel sheet

1 次查看（过去 30 天）
abdul rehman
abdul rehman 2020-7-14
评论： Walter Roberson 2020-7-14
how can I search a name in the excel sheet column, the code should return the 0 or 1, or found or not found.

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

回答（1 个）

Walter Roberson
Walter Roberson 2020-7-14
readtable() the needed columns. ismember() the desired name with the table column variable as the second parameter.
Note: if you are doing that "distance between cities" exercise then you will have more work than I described above, because of the header line
  4 个评论
显示 2更早的评论
abdul rehman
abdul rehman 2020-7-14
Actually, Sorry i am unable to clearify you. The issue is that the is stored in excel file is showing as NaN means noting or empty cell, when i retrive using xlsread or readtalbe.

请先登录，再进行评论。

类别

在 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