returns a column vector v of the nonzero entries in X, as well as row and column indices.
i æå¨è¡
j æå¨å
v 符åæ¡ä»¶çæ°
追é®å¯¹äºï¼æè¿æ³ç¥éæä¹æexcelä¸è¿ä¸ååºå¤§çæ°æ®åæä¸ä¸ªæ°ç»Xå½å ¥matlab?
追ç>>doc xlsread
xlsread
Read Microsoft Excel spreadsheet file (.xls)
Syntax
num = xlsread('filename')
num = xlsread('filename', -1)
num = xlsread('filename', sheet)
num = xlsread('filename', 'range')
num = xlsread('filename', sheet, 'range')
num = xlsread('filename', sheet, 'range', 'basic')
num = xlsread('filename', ..., functionhandle)
[num, txt] = xlsread('filename', ...)
[num, txt, raw] = xlsread('filename', ...)
[num, txt, raw, X] = xlsread('filename', ..., functionhandle)
xlsread filename sheet range basic
Description
num = xlsread('filename') returns numeric data in double array num from the first sheet in the Microsoft Excel spreadsheet file named filename. The xlsread ignores leading rows or columns of text. However, if a cell not in a leading row or column is empty or contains text, xlsread puts a NaN in its place in the return array, num