MATLAB Answers

checking excel cell values using matlab

3 views (last 30 days)
Dhandapani.S
Dhandapani.S on 9 Mar 2017
Commented: Image Analyst on 11 Mar 2017
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 Comments
Image Analyst
Image Analyst on 10 Mar 2017
Make this an answer below, in the answer section along with the other answers, not a comment.

Sign in to comment.

Answers (1)

Image Analyst
Image Analyst on 10 Mar 2017
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 Comments
Image Analyst
Image Analyst on 11 Mar 2017
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().

Sign in to comment.

Community Treasure Hunt

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

Start Hunting!