仿真matlab典算法程序.pdfVIP

xlsread

ReadExcelspreadsheetfile(.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)

xlsreadfilenamesheetrangebasic

Description

num=xlsread(filename)returnsnumericdataindoublearraynumfrom

thefirstsheetintheExcelspreadsheetfilenamedfilename.Thexlsread

ignoresleadingrowsorcolumnsoftext.However,ifacellnotinaleadingroworcolumnis

emptyorcontainstext,xlsreadputsaNaNinitsplaceinthereturnarray,num.

ThefullfunctionalityofxlsreaddependsontheabilitytostartExcelasaCOMserverfrom

MATLAB.Ifyoursystemdoesnothavethiscapability,thexlsreadsyntaxthatpassesthe

basickeywordisrecommended.AslongastheCOMserverisavailable,youcanuse

xlsreadonExcelfileshavingformatsotherthanXLS(forexample,HTML).

NotexlsreadonUNIXisbeinggrandfathered.IftheExcelCOMserverisnot

available,xlsreadreadsonlystrictlyXLSfiles.ItcannotreadExcelfilessaved

inHTMLorotherformats.

num=xlsread(filename,-1)opensthefilefilenameinanExcel

window,enablingyoutointeractivelyselecttheworksheettobereadandtherangeofdata

onthatworksheettoimport.Toimportanentireworksheet,firstselectthesheetintheExcel

windowandthenclicktheOKbuttonintheDataSelectionDialogbox.Toimportacertain

rangeofdatafromthesheet,selecttheworksheetintheExcelwindow,draganddropthe

mouseov