checking excel cell values using matlab

Question

Dhandapani.S 2017-3-9

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/329072-checking-excel-cell-values-using-matlab

评论： Image Analyst 2017-3-11

hai i am Dhandapani. i used the following code to check the excel value. it should say true because the exact value in the partucular cell is '0.43916'. i even used xlsread to find . it displayed '0.4392'. i even changed the search valueto '0.4392' but the answer is 'no'. but when i checked for whole numbers like '45' it says 'yes'. kindly help in this regard. the code is as follows. after this i have to check for 5 cell values of excel for a pattern match. is this possible in matlab? Thanks in advance if xlsread('realsys1.xls', 'Sheet1', 'a1:a1') == 0.43916 display 'yes' else display 'no' end

2 个评论
显示无隐藏无

kowshik Thopalli 2017-3-10

在 MATLAB Online 中打开

This looks like a format problem. Use

format long

Will that solve your problem. The general recommendation to check float numbers a1 and a2 is that to not use directly a1==a2 but to use

abs(a1-a2)<epsilon.

where epsilon is a very small value like 0.001 or something similar.

Image Analyst 2017-3-10

Make this an answer below, in the answer section along with the other answers, not a comment.

请先登录，再进行评论。

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

Answer 1

Image Analyst 2017-3-10

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/329072-checking-excel-cell-values-using-matlab#answer_258107

Not surprising. It won't be to you either, after you read the FAQ: http://matlab.wikia.com/wiki/FAQ#Why_is_0.3_-_0.2_-_0.1_.28or_similar.29_not_equal_to_zero.3F

3 个评论
显示 1更早的评论隐藏 1更早的评论

Dhandapani.S 2017-3-11

to be clear, i need to get a number(say 23.5444)as input using matlab and find in which row of an excel file, the number exists.

Image Analyst 2017-3-11

Did you try the code in the FAQ I referred you to? See where it says to look within a tolerance? If you have a new version of MATLAB, you can use ismembertol().

请先登录，再进行评论。