xls read doesn't work on Mac

8 views (last 30 days)
Daniel Thomas
Daniel Thomas on 8 Jan 2020
Commented: Walter Roberson on 29 Jan 2020
doesnt read a masterfile
  1 Comment
Guillaume
Guillaume on 8 Jan 2020
Edited: Guillaume on 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.

Sign in to comment.

Answers (1)

Ram Vijayaragavan
Ram Vijayaragavan on 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 Comment
Walter Roberson
Walter Roberson on 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.

Sign in to comment.

Tags

Community Treasure Hunt

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

Start Hunting!