Releases R2016a and later respect sheet and range values for XLSREAD.
XLSREAD and XLSWRITE are built on COM Automation, a Microsoft technology for inter-program communication that is not fully available on Mac OS.
As noted in the help documentation for the XLSREAD function, the full functionality of these functions depends on the ability to start Excel as a COM server. This is currently not a feature for Microsoft Excel on non-Windows platforms.
Without Excel as a COM server, the range specification will be ignored and, consequently, the whole active range of a sheet will be imported. Also, the sheet specification is case-sensitive and must be a string.
Best Answer