how to search specific data from matlab to excel

1 次查看（过去 30 天）
Mettri Wibawanti
Mettri Wibawanti 2021-10-25
评论： Ive J 2021-10-26
how to search specific data from matlab to excel and then display the row that include the data i've searched to matlab, for example i have an excel data
R1280XS 11 12 10
B2015AT 14 10 10
D1112FM 10 14 15
when i search R1280XS at matlab, 11 12 10 will display in matlab
please help me, i'm stuck with it

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

采纳的回答

Ive J
Ive J 2021-10-25
tab = readtable('myExcel.xlsx'); % see doc for more options
tab(ismember(tab.(1), 'R1280XS'), :) % the row at which the input str matches the first table's column
  2 个评论
Mettri Wibawanti
Mettri Wibawanti 2021-10-25
编辑：Mettri Wibawanti 2021-10-25
its work! thank you so much, but may i ask again, how if i use like
T = input ('plate number :','s'); %and then i put R1280XS
tab(ismember(tab.(1), 'T'), :)
why it can't shows it ? thank you, i really appreciate your help :)
Ive J
Ive J 2021-10-26
Just change your second line to:
tab(ismember(tab.(1), T), :)

请先登录，再进行评论。

更多回答（0 个）

类别

在 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