How to get the value corresponding to the data in an excel file

2 次查看（过去 30 天）
Yavuzhan Canakci
Yavuzhan Canakci 2022-3-29
回答： Arif Hoq 2022-3-30
Hi,
I am trying to write an algorithm that calculates the values entered by the user and obtains a result, and prints the value in the 1st column corresponding to this result.
For now, let's ignore the initial calculations and get the result of the calculation directly from the user. This is how I did it;
T = readtable('katalog.xlsx');
in = input('Enter Input\n','s');
For example, the user found the answer 13.2 as a result.
Matlab should compare this result with the closest value in the excel file and output the text in the 1st column corresponding to that value.
You can check my excel file in the attachment.
Despite doing a lot of research, I couldn't find exactly how to do this. If you can help me with this, that would be great.

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

回答（1 个）

Arif Hoq
Arif Hoq 2022-3-30
Ran in:
try this:
A=readtable('katalog.xlsx','ReadVariableName',false);
B=table2array(A(2:end,2:end));
D=str2double(string(B));
userinput=36.1; % you can defined in a function "input"
[~,~,idx]=unique(round(abs(D-userinput)));
minVal=D(idx==1)
minVal = 36
[row col]=find(D==minVal);
output=A(row+1,1)
output = table
Var1 _______ {'AB8'}

类别

在 Help Center 和 File Exchange 中查找有关 Database Toolbox 的更多信息

标签

产品


版本

R2021b

Community Treasure Hunt

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

Start Hunting!

Translated by