function?varargout?=?readfromexcel（filelocvarargin）
%?VARARGOUT?=?READFROMEXCEL（FILELOCVARARGIN）
%
%?????????????Uses?ActiveX?commands?to?read?range（s）?from?an?existing?Excel
%?????????????spreadsheet.
%
%?FILELOC:????????????Enter?a?string?representing?the?（absolute?or?relative）?
%?????????????????????location?of?an?Excel?file.?（Extension?may?be
%?????????????????????omitted?and?will?be?assumed?to?be?.xls.）
%?????????????????????Examples:?‘c:\brett\my?archives\test1.xls‘
%???????????????????????????????‘test1.xls‘
%???????????????????????????????‘myarchive‘
%
%?SHEETNAME:??????????（Optional）:?Any?occurrence?in?the?variable?argument?list?of
%?????????????????????the?strings?‘sheetname‘?or?‘sheet‘?prompts?the?function?to?change
%?????????????????????active?sheets?to?the?value?in?the?following?variable.?That?specifier
%?????????????????????must?be?a?string?argument?matching?exactly?the?name?of?an?existing?
%?????????????????????sheet?in?the?opened?file.?If?this?argument?is?omitted?the?function
%?????????????????????defaults?to?reading?from?the?first?sheet?in?the?file.
%
%?RANGE?SPECIFIER（S）:?Enter?the?range（s）?to?read.?The?values?stored?in?these
%?????????????????????ranges?will?be?returned?in?consecutive?output?arguments.
%?????????????????????Example:?‘B1:B5‘
%??????????????????????????????‘B1:B1‘?（or?simply?‘B1‘）
%??????????????????????????????‘B1:P4‘
%??????????????????????????????‘B:B‘?or?‘B‘?（Entire?second?column）
%??????????????????????????????‘2:2‘?or?‘2‘?（Entire?second?row）
%??????????????????????????????‘ALL‘?（Entire?sheet）
%??????（Additional?ranges:?Comma?separated?ranges?in?the?same?form?as?above;
%????????????????contents?of?archive?will?be?returned?in?output?arguments
%????????????????2...n）
%
%?NOTE:???????????????Specifying?range?as?‘ALL‘?returns?entire?used?portion?of?sheet;
%?????????????????????Specifying?range?as?‘B:B‘?or?‘2:2‘?returns
%?????????????????????appropriate?row?of?UsedRange.?（Data?are?selected?in
%?????????????????????block?form?as?for?‘ALL‘?then?the?selected?row/column
%?????????????????????is?returned.
%
%?OUTPUT:?If?specified?range?is?1?cell?variable?returned?is?of?the?same
%?????????class?as?cell?contents.?If?the?range?spans?more?than?1?cell?the?variables?will?be?cell?arrays.
%
%?EXAMPLES:???a?=?readfromexcel（‘c:\brett\my?archives\test1.xls‘‘C1:C5‘）;
%?????????????????reads?from?the?currently?active?sheet
%?????????????[ab]?=?readfromexcel（‘c:\brett\my?archives\test1.xls‘‘sheet‘‘sheet2‘‘C1:C5‘‘C1:P3‘）;
%?????????????????reads?from?sheet2
%?????????????[abc]?=?readfromexcel（‘myarchive‘‘C3:D5‘‘sheet‘‘mysheet‘‘E4‘‘sheet‘‘sheet2‘‘B3‘）;
%?????????????????reads?a?from?currently?active?sheet?switches?to?sheet
%?????????????????‘mysheet‘?to?read?b?then?to?sheet?‘sheet2‘?to?read?c.
%
%?Written?by?Brett?Shoelson?Ph.D.
%?shoelson@helix.nih.gov
%?Update?History:?1/04.?Version?1.
%?????????????????2/2/04.?Now?allows?multiple?specifications?of?sheet?na

?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----

?????文件????????103??2010-04-01?23:01??data.txt

?????文件?????????54??2010-04-01?23:09??kq2010.txt

?????文件???????1335??2009-05-26?09:51??ReadFromExcel\license.txt

?????文件???????8586??2009-05-26?09:51??ReadFromExcel\ReadFromExcel.m

?????文件?????325433??2010-04-01?22:53??MATLAB?Central?-?File?detail?-?readfromexcel.mht

?????文件??????13824??2010-04-01?22:59??data.xls

?????文件??????29696??2010-04-01?23:06??kq2010.xls

?????目錄??????????0??2010-04-01?22:55??ReadFromExcel

-----------?---------??----------?-----??----

???????????????379031????????????????????8