How can I use function to give me a variable from an excel file?

2 次查看（过去 30 天）
Claudia Ganhao Gomez
回答： Srijith Kasaragod 2021-11-22
I am trying to write a code that using user defined function I can get an answer from an excel file. In other words, I have an excel file that has years in the first column and values in the second, how can I use function for the user to enter a year from 1990 to 2018 and the answer to be whatever variable is assigned to that year from the excel file?

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

回答（1 个）

Srijith Kasaragod
Srijith Kasaragod 2021-11-22
Hi Claudia,
Following lines of code shows one of the ways you could solve your problem:
tbl= readtable('excel.xlsx');
%variable year stores the user input
%Year and Answer are the column names of the table
[outa, outb]= ismember(year,tbl.Year);
sol= tbl.Answer(outb);
Please refer 'ismember' documentation to read more on how to verify if certain elements are members of a set array.

类别

在 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