how to search specific data from matlab to excel

1 Ansicht (letzte 30 Tage)
Mettri Wibawanti
Mettri Wibawanti am 25 Okt. 2021
Kommentiert: Ive J am 26 Okt. 2021
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

Melden Sie sich an, um diese Frage zu beantworten.

Akzeptierte Antwort

Ive J
Ive J am 25 Okt. 2021
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 Kommentare
Mettri Wibawanti
Mettri Wibawanti am 25 Okt. 2021
Bearbeitet: Mettri Wibawanti am 25 Okt. 2021
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 am 26 Okt. 2021
Just change your second line to:
tab(ismember(tab.(1), T), :)

Melden Sie sich an, um zu kommentieren.

Weitere Antworten (0)

Kategorien

Mehr zu Spreadsheets finden Sie in Help Center und File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!

Translated by