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
xlsread includes an option to open Excel and
select the range of data interactively. To use this option, call
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.
Note: Large files in XLSX format sometimes load slowly. For better import and export performance, Microsoft® recommends that you use the XLSB format.
If your system does not have Excel for Windows installed, or the COM server is not available:
All MATLAB import options read XLS, XLSX, XLSM, XLTM, and XLTX files.