How to read numbers spreadsheets from Mac using Matlab

24 次查看（过去 30 天）
Stelios Fanourakis
Stelios Fanourakis 2019-10-30
回答： Cris LaPierre 2021-1-7
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 个评论
显示 2更早的评论
Guillaume
Guillaume 2020-1-15
In any case, I don't think there's any function in matlab that can read numbers files, which are neither text files nor excel files. If the file has been exported as an excel file then yes it could be read with xlsread or better readtable or readmatrix but the file is no longer a numbers file.
Of course, csvread, dlmread and co. have never been able to read excel files. Only text files.
Walter Roberson
Walter Roberson 2020-1-15
If the file is xls or xlsx then unless Windows with Excel is being used, it may be necessary to use readtable.

请先登录，再进行评论。

请先登录，再回答此问题。

回答（2 个）

Jyotsna Talluri
Jyotsna Talluri 2019-11-4
'xlsread' is not recommended in the latest versions .Instead try using 'readtable'
Cris LaPierre
Cris LaPierre 2021-1-7
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.

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by