Discover MakerZone

MATLAB and Simulink resources for Arduino, LEGO, and Raspberry Pi

Learn more

Discover what MATLAB® can do for your career.

Opportunities for recent engineering grads.

Apply Today

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?


the cyclist


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.


the cyclist

Contact us