xls read doesn't work on Mac
8 views (last 30 days)
Show older comments
doesnt read a masterfile
1 Comment
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.
Answers (1)
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
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.
See Also
Categories
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!