MATLAB Answers

the cyclist

Spreadsheet import tool in 2011b

Asked by the cyclist
on 7 Sep 2011

Will the new Spreadsheet Import Tool introduced in 2011b work on a Mac, for *.xlsx (or any other Excel-type) files?


1 Answer

Answer by the cyclist
on 17 Sep 2011
 Accepted answer

I raised this issue directly with Mathworks support. Here is the reply I received:

The ability to read XLSX files is not available on the Mac OS. On the Mac OS, MATLAB does support a 'BASIC' mode that works with XLS files that are saved in the "Excel 97-2003" format. Since the connection to Excel is based on the Microsoft specific COM technology, all functionalilites of Excel are not available on the Mac OS.

In order to work around this issue, please use the following steps: [1] Copy the data into a new Excel Workbook and saved it as a 'Excel 97-2003' with a '.xls' file extension (I named this file 'test.xls'). [2] Using XLSREAD on Mac OS, read the data from the XLS file mentioned in step 1.

Alternatively, you could save the data as a Comma Separated Values (CSV) file and read it using CSVREAD. Please note that CSVREAD works only for numeric values. For more documentation on CSVREAD, please use the following command at the MATLAB command line.


Discover what MATLAB® can do for your career.

Opportunities for recent engineering grads.

Apply today