How to give input as a text and read the number corresponding to that text from the excel sheet
1 vue (au cours des 30 derniers jours)
Afficher commentaires plus anciens
Harsimranjot Grewal
le 11 Mai 2021
Commenté : Harsimranjot Grewal
le 12 Mai 2021
Hello everyone, I am trying to write a code which takes an input argument in the form of the text from the user and then matlab find that word in the excel sheet and return the number corresponding to it.The excel file will be as follow:
Material name Material temprature
steel 212
zinc 300
** I have only put two materials but iit will be around 200 matrials in the real excel file
So, If i put the steel and it should return 212 but I not able to get it.Any help will be appreciated.Thank you
0 commentaires
Réponse acceptée
Monika Jaskolka
le 11 Mai 2021
Modifié(e) : Monika Jaskolka
le 11 Mai 2021
data = readtable('Spreadsheet.xlsx');
entry = data(strcmp(data.MaterialName, 'zinc'), :);
entry.MaterialTemperature
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Data Import from MATLAB dans Help Center et File Exchange
Produits
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!