how to search specific data from matlab to excel

2 vues (au cours des 30 derniers jours)
Mettri Wibawanti
Mettri Wibawanti le 25 Oct 2021
Commenté : Ive J le 26 Oct 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

Réponse acceptée

Ive J
Ive J le 25 Oct 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 commentaires
Mettri Wibawanti
Mettri Wibawanti le 25 Oct 2021
Modifié(e) : Mettri Wibawanti le 25 Oct 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 le 26 Oct 2021
Just change your second line to:
tab(ismember(tab.(1), T), :)

Connectez-vous pour commenter.

Plus de réponses (0)

Catégories

En savoir plus sur Data Import from MATLAB dans Help Center et File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by