Read Microsoft Excel spreadsheet file
expand all in page
Syntax
num = xlsread(filename) example
num = xlsread(filename,sheet)
num = xlsread(filename,xlRange) example
num = xlsread(filename,sheet,xlRange) example
num = xlsread(filename,sheet,xlRange,'basic')
[num,txt,raw] = xlsread(___) example
___ = xlsread(filename,-1)
[num,txt,raw,custom] = xlsread(filename,sheet,xlRange,'',functionHandle) example


Description

example
num = xlsread(filename) reads data from the first worksheet in the Microsoft® Excel® spreadsheet file named filename and returns the numeric data in array num. 
On Windows® systems with Microsoft Excel software, xlsread reads any file format recognized by your version of Excel.
If your system does not have Excel for Windows, xlsread operates in basic import mode, and reads only XLS, XLSX, XLSM, XLTX, and XLTM files.

num = xlsread(filename,sheet) reads the specified worksheet.

example
num = xlsread(filename,xlRange) reads data from the specified range, xlRange, of the first worksheet in the file. 

example
num = xlsread(filename,sheet,xlRange) reads from the specified sheet and range, xlRange. 

num = xlsread(filename,sheet,xlRange,'basic') reads data from the spreadsheet in basic mode, the default on systems without Excel for Windows. If you do not specify all the arguments, use empty strings as placeholders, for example, num = xlsread(filename,'','','basic').

example
[num,txt,raw] = xlsread(___) additionally returns the text fields in cell array txt, and the unprocessed data (numbers and text) in cell array raw using any of the input arguments in the previous syntaxes. If xlRange is specified, leading blank rows and columns in the worksheet that precede rows and columns with data are returned in raw. 


___ = xlsread(filename,-1) opens an Excel window to interactively select data. Select the worksheet, drag and drop the mouse over the range you want, and click OK. This syntax is supported only on Windows systems with Excel software.


example
[num,txt,raw,custom] = xlsread(filename,sheet,xlRange,'',functionHandle) reads from the spreadsheet, executes the function associated with functionHandle on the data, and returns the final results as numeric data in array num. The xlsread function optionally returns the text fields in cell array txt, the unprocessed data (numbers and text) in cell array raw, and the second output from the function associated with functionHandle in array custom. The xlsread function does not change the data stored in the spreadsheet. This syntax is supported only on Windows systems with Excel software.