checking excel cell values using matlab
1 vue (au cours des 30 derniers jours)
Afficher commentaires plus anciens
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 commentaires
kowshik Thopalli
le 10 Mar 2017
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
le 10 Mar 2017
Make this an answer below, in the answer section along with the other answers, not a comment.
Réponses (1)
Image Analyst
le 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 commentaires
Image Analyst
le 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().
Voir également
Catégories
En savoir plus sur Data Import from MATLAB dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!