Why does XLSREAD read wrong values for certain negative numbers?

Question

0 个投票

For example, consider an Excel file that has the following values:

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