xls read doesn't work on Mac

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

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

Asked:

on 8 Jan 2020

Commented:

on 29 Jan 2020

Community Treasure Hunt

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

Start Hunting!