help xlsread
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).
注意matlab不识别中文，读写的文件中最好不含有中文
excel读取函数 xlsread
text 读取函数csvread
XLSREAD Get data and text from a spreadsheet in an Excel
workbook.
[NUMERIC,TXT,RAW]=XLSREAD(FILE) reads the data specified in the
Excel
file, 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.
[NUMERIC,TXT,RAW]=XLSREAD(FILE,SHEET,RANGE) reads the data
specified
in RANGE
from the worksheet SHEET, in the Excel file specified in
FILE.
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 available 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.
[NUMERIC,TXT,RAW]=XLSREAD(FILE,SHEET,RANGE,'',CUSTOMFUN)
[NUMERIC,TXT,RAW,CUSTOMOUTPUT]=XLSREAD(FILE,SHEET,RANGE,'',CUSTOMFUN)
When the
Excel COM server is used, allows passing in a handle to a
custom
function. This function will be called just
before retrieving
the actual
data from Excel. It must take an Excel Range object (e.g. of
type
'Interface.Microsoft_Excel_5.0_Object_Library.Range') as
input,
and return
one as output. Optionally, this custom function
may return
a second
output argument, which will be returned from XLSREAD as the
fourth
output argument, CUSTOMOUTPUT. For details of
what is possible
using the
EXCEL COM interface, please refer to Microsoft documentation.
INPUT
PARAMETERS:
FILE: string
defining the file to read from. Default directory is pwd.
Default extension is 'xls'.
SHEET:
string defining worksheet name in workbook FILE.
double scalar defining worksheet index in workbook FILE. See
NOTE 1.
RANGE:
string defining the data range in a worksheet. See NOTE 2.
MODE: string
enforcing basic import mode. Valid value =
'basic'. This
is the mode
always used when COM is not available (e.g. on Unix).
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 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')
6. Get data
from a specified region in a named sheet:
NUMERIC =
xlsread('c:\matlab\work\myspreadsheet','NBData','a2:j5')
7. Get data
from a region in a sheet specified by index:
NUMERIC = xlsread('c:\matlab\work\myspreadsheet',2,'a2:j5')
加载中…