MATLAB: Problem with xlsread.

excel

Hello, everyone¡
I'm trying to read a .xls file using the xlsread code from matlab, after a lot of fail attempts, I just can not do it by my self, so I save the file in .txt format (from the .xls) and was easy to read using textscan, because I can differentiate each column of the data matrix with this simple format.
%f-%3c-%f %f:%f:%f %f %f %f
Well, I'm just wondering if is possible to read this kind of data, using the xlsread or any other code, directly from the exel file.
Thanks for your time.
.xls file
     Date:  [2009-12-13,2014-07-21]  
      
    [Min] m/s Velocidad de Viento[2m]  [Prom] m/s Velocidad de Viento[2m]
  2009-12-13 00:00:00  3.94  4.01
  2009-12-13 01:00:00  3.00  3.44
  2009-12-13 02:00:00  1.82  2.71
  2009-12-13 03:00:00  2.83  3.03
  2009-12-13 04:00:00  1.76  1.91
  2009-12-13 05:00:00  0.84  1.90
  2009-12-13 06:00:00  3.43  
  2009-12-13 07:00:00  1.55  2.15
  2009-12-13 08:00:00  0.18  0.80
  2009-12-13 09:00:00  1.05  1.47
  2009-12-13 10:00:00  3.35  3.72
  2009-12-13 11:00:00    3.89
  2009-12-13 12:00:00  4.75  4.77
  2009-12-13 13:00:00  5.11  5.15
  2009-12-13 14:00:00  4.49  4.69
  2009-12-13 15:00:00  3.64  3.90
  2009-12-13 16:00:00  3.12  4.490
  Date:  [2009-12-13,2014-07-21]

Best Answer

That particular .xls file is not readable with xlsread() for OS-X, at least not on my R2014a release (and probably not in versions up to R2015b either as that code did not change.)
The file is a binary .xls file; only text .xls and .csv and .xlsx files can be read in Basic Mode in MATLAB on OS-X or Linux or on MS Windows systems that do not have Excel installed.
You would need to arrange to have the file saved in a different format to read it in MATLAB on OS-X.
Related Question