xls read doesn't work on Mac

8 vues (au cours des 30 derniers jours)
Daniel Thomas
Daniel Thomas le 8 Jan 2020
Commenté : Walter Roberson le 29 Jan 2020
doesnt read a masterfile
  1 commentaire
Guillaume
Guillaume le 8 Jan 2020
Modifié(e) : Guillaume le 8 Jan 2020
What is a master file?
xlsread on a Mac is indeed restricted to basic mode which is limited in what it can read.
xlsread has long been deprecated in favour of readtable, readmatrix, or readcell which should perform better particularly in newer versions of matlab.

Connectez-vous pour commenter.

Réponses (1)

Ram Vijayaragavan
Ram Vijayaragavan le 29 Jan 2020
This is an issue in MATLAB on the Mac OS X in the way that the XLSREAD function handles files with more than 500 rows.
For all releases up to MATLAB R2012a, use the WK1READ function.
  1 commentaire
Walter Roberson
Walter Roberson le 29 Jan 2020
Master files contain embedded references to sql databases. As far as I know, such files require ActiveX connections to excel to be read, which is not possible on Mac or Linux.

Connectez-vous pour commenter.

Tags

Community Treasure Hunt

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

Start Hunting!

Translated by