Readtable .xls error in MacOS

11 visualizaciones (últimos 30 días)
도연 원
도연 원 el 23 de Sept. de 2022
Comentada: 도연 원 el 24 de Sept. de 2022
Hi, guys.
I have a trouble with readtable function.
In Mac OS, readtable won't work with .xls file. Matlab shows error message of do I have authorization with accessing the file, or does file really exist.
And just for the record, my Mac's preference setting/ folder and files is all checked status for Matlab, so it is not the problem for accessing the file. and... I am using M1 Pro Macbook 16.
However when I try - I use also windows - readtable, with same .xls file in the windows Matlab, it works problem-free.
And also... When I change .xls file into .xlsx file and readtable in the MacOS, it works.
So... Is Matlab not supporing .xls files to be read in 'readtable' function in MacOS?

Respuestas (1)

HYEONSEOK SEOK
HYEONSEOK SEOK el 23 de Sept. de 2022
I need to know the error text or version when using it.
Possible issues are that xlsread is used(this may not be the case)., the path is set to (\), or it's a MATLAB version issue (under 2014) . Also, there may be cases where the sheet rows are duplicated, so please use .csv if possible.
https://kr.mathworks.com/matlabcentral/answers/845910-why-readtable-function-cannot-read-an-xlsx-file-properly
  1 comentario
도연 원
도연 원 el 24 de Sept. de 2022
서비스 요청하기로 문의드려도 되나요?

Iniciar sesión para comentar.

Categorías

Más información sobre Matrix Indexing en Help Center y File Exchange.

Etiquetas

Productos


Versión

R2022a

Community Treasure Hunt

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

Start Hunting!

Translated by