MATLAB Answers

How to read numbers spreadsheets from Mac using Matlab

조회 수: 27(최근 30일)
Stelios Fanourakis
Stelios Fanourakis 30 Oct 2019
Commented: Walter Roberson 15 Jan 2020 16:41
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

표시 이전 댓글 수: 1
Walter Roberson
Walter Roberson 15 Jan 2020 15:08
csvread never supported named ranges. csvread is not just another name for xlsread.
Guillaume
Guillaume 15 Jan 2020 16:33
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 15 Jan 2020 16:41
If the file is xls or xlsx then unless Windows with Excel is being used, it may be necessary to use readtable.

로그인 to comment.

답변 수 (1)

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

  댓글 수: 0

로그인 to comment.

이 질문에 답변하려면 로그인을(를) 수행하십시오.


Translated by