Matlab 导入EXCEL数据-经管之家官网！

在Matlab命令窗口中使用xlsread函数
注意啦：在较低版本的Matlab无法识别xlsx文件（即EXCEL2007文件），可以将其转换为XLS文件后在使用Matlab打开
XLSREAD Get data and text from a spreadsheet in an Excel workbook.
[NUMERIC,TXT,RAW]=XLSREAD(FILE,SHEET,RANGE) reads the data specified
in RANGE from the worksheet SHEET, in the Excel file specified in FILE. The
numeric cells in FILE are returned in NUMERIC, the text cells in FILE are
returned in TXT, while the raw, unprocessed cell content is returned in
RAW. It is possible to select the range of data interactively (see Examples
below). Please note that the full functionality of XLSREAD depends on the
ability to start Excel as a COM server from MATLAB.
[NUMERIC,TXT,RAW]=XLSREAD(FILE,SHEET,RANGE,'basic') reads an XLS file as
above, using basic input mode. This is the mode used on UNIX platforms
as well as on Windows when Excel is not availabe as a COM server.
In this mode, XLSREAD does not use Excel as a COM server, which limits
import ability. Without Excel as a COM server, RANGE will be ignored
and, consequently, the whole active range of a sheet will be imported.
Also, in basic mode, SHEET is case-sensitive and must be a string.
INPUT PARAMETERS:
FILE: string defining the file to read from. Default directory is pwd.
Default extension is 'xls'. See NOTE 1.
SHEET: string defining worksheet name in workbook FILE.
double scalar defining worksheet index in workbook FILE.
RANGE: string defining the data range in a worksheet. See NOTE 2.
MODE: string enforcing basic import mode. Valid value = 'basic'.
RETURN PARAMETERS:
NUMERIC = n x m array of type double.
TXT = r x s cell string array containing text cells in RANGE.
RAW = v x w cell array containing unprocessed numeric and text data.
Both NUMERIC and TXT are subsets of RAW.
EXAMPLES:
1. Default operation:
NUMERIC = xlsread(FILE);
[NUMERIC,TXT]=xlsread(FILE);
[NUMERIC,TXT,RAW]=xlsread(FILE);
2. Get data from the the default region:
NUMERIC = xlsread('c:\matlab\work\myspreadsheet')
3. Get data from the used area in a sheet other than the first sheet:
NUMERIC = xlsread('c:\matlab\work\myspreadsheet','sheet2')
4. Get data from a named sheet:
NUMERIC = xlsread('c:\matlab\work\myspreadsheet','NBData')
5. Get data from a specified region in a sheet other than the first
sheet:
NUMERIC = xlsread('c:\matlab\work\myspreadsheet','sheet2','a2:j5')

7. Get data from a specified region in a named sheet:
NUMERIC = xlsread('c:\matlab\work\myspreadsheet','NBData','a2:j5')

8. Get data from a region in a sheet specified by index:
NUMERIC = xlsread('c:\matlab\work\myspreadsheet',2,'a2:j5')

9. Interactive region selection:
NUMERIC = xlsread('c:\matlab\work\myspreadsheet',-1);
You have to select the active region and the active sheet in the
EXCEL window that will come into focus. Enter any letter at Matlab
command line when finish selecting the active region.
NOTE 1: If FILE is the empty string or omitted, an error is thrown.
NOTE 2: The first worksheet of the workbook is the default sheet. If SHEET
is -1, Excel comes to the foreground to enable interactive selection
(optional). In interactive mode, a dialogue will prompt you to click
the OK button in that dialogue to continue in MATLAB.
NOTE 3: The regular form is: 'D2:F3' to select rectangular region D2:F3 in a
worksheet. RANGE is not case sensitive and uses Excel A1 notation.
(see Excel Help).