|On this page…|
If your system has Excel® for Windows® installed, including the COM server (part of the typical installation of Excel):
All MATLAB® import options support XLS, XLSX, XLSB, XLSM, XLTM, and XLTX formats.
xlsread also imports HTML-based formats.
xlsread includes an option to open Excel and select the range of data interactively. To use this option, call xlsread with the following syntax:
mydata = xlsread(filename, -1)
If you have Excel 2003 installed, but want to read a 2007 format (such as XLSX, XLSB, or XLSM), install the Office 2007 Compatibility Pack.
If you have Excel 2010, all MATLAB import options support ODS files.