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

10 views (last 30 days)
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.

Answers (1)

Arif Hoq
Arif Hoq on 30 Mar 2022
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'}

Products


Release

R2021b

Community Treasure Hunt

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

Start Hunting!

Translated by