How to give input as a text and read the number corresponding to that text from the excel sheet

1 次查看（过去 30 天）
Harsimranjot Grewal
评论： Harsimranjot Grewal 2021-5-12
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

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

采纳的回答

Monika Jaskolka
Monika Jaskolka 2021-5-11
编辑：Monika Jaskolka 2021-5-11
data = readtable('Spreadsheet.xlsx');
entry = data(strcmp(data.MaterialName, 'zinc'), :);
entry.MaterialTemperature

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Data Import from MATLAB 的更多信息

标签

产品

Community Treasure Hunt

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

Start Hunting!

Translated by