MATLAB Answers

How to read numbers spreadsheets from Mac using Matlab

53 views (last 30 days)
Stelios Fanourakis
Stelios Fanourakis on 30 Oct 2019
Answered: Cris LaPierre on 7 Jan 2021
Hi
I am using the xlsread command to read numbers spreadsheets in Matlab but I get the error that cannot find the file. The file is in the folder but cannot find it. Why? I don't get any error with the xlsread command. Can Matlab see number spreadsheets? It has been saved as the one the Numbers app of Mac exports
  4 Comments
Walter Roberson
Walter Roberson on 15 Jan 2020
If the file is xls or xlsx then unless Windows with Excel is being used, it may be necessary to use readtable.

Sign in to comment.

Answers (2)

Jyotsna Talluri
Jyotsna Talluri on 4 Nov 2019
'xlsread' is not recommended in the latest versions .Instead try using 'readtable'

Cris LaPierre
Cris LaPierre on 7 Jan 2021
MATLAB does not appear to be able to read these files directly. The recommended workaround is to export the file as a *.xlsx or *.csv file, then import using readtable. Other methods for importing can be found here.

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!