Why does XLSREAD read wrong values for certain negative numbers?
3 views (last 30 days)
Show older comments
Why does XLSREAD read wrong values for certain negative numbers?
For example, consider an Excel file that has the following values:
-112.40
-23071.36
-23072.36
-23088.3
-23130.67
-23131.42
-23153.65
Using XLSREAD on the above XLS file, say test.xls yields the following results:
a = xlsread(['test.xls'])
a =
1.0e+007 *
-0.00001124000000
-0.00230713600000
1.07143458800000
1.07143299400000
1.07142875700000
1.07142868200000
1.07142645900000
Accepted Answer
MathWorks Support Team
on 27 Jun 2009
This was a bug in MATLAB 6.0 (R12)which has been fixed in MATLAB 6.1 (R12.1).
There are no known workarounds for MATLAB 6.0 (R12)
0 Comments
More Answers (0)
See Also
Categories
Find more on Get Started with MATLAB in Help Center and File Exchange
Products
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!