matlab与excel数据交换的有利工具

《matlab与excel数据交换的有利工具》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。

1、matlab与excel数据交换的有利工具——excellink(1)WhatIsExcelLink?ExcelLinkisasoftwareadd-inthatintegratesMicrosoftExcelandMATLABinaMicrosoftWindows-basedcomputingenvironment.ByconnectingExcelandMATLAB,youcanaccessthenumerical,computational,andgraphicalpowerofMATLABfromExcelworksheetand

2、macroprogrammingtools.ExcelLinkletsyouexchangeandsynchronizedatabetweenthetwoenvironments.1.SystemRequirements2.InstallingExcelLink3.ConfiguringExceltoWorkwithExcelLink4.StartingExcelLink5.ConnectingtoanExistingMATLABSession6.StoppingExcelLinkFollowtheseinstructionstoinst

3、allExcelLinkandthenconfigureExcel.SystemRequirementsExcelLinkrequiresapproximately202kilobytesofdiskspace.Operatingsystemrequirementsare:MicrosoftWindowsXP，MicrosoftWindows2000ExcelLinkalsorequiresoneofthefollowingversionsofExcel:Excel2000Excel，2002Excel，2003Excel（ExcelLi

4、nkhasalsobeenqualifiedagainstExcel2007Beta.）ExcelLinkalsorequiresMATLABforWindows.ForbestresultswithMATLABfiguresandgraphics,setthecolorpaletteofyourdisplaytoavaluegreaterthan256colors.ClickStart>Settings>ControlPanel>Display,andthenclicktheSettingstab.Chooseanappropriate

5、entryfromtheColorPalettemenu.InstallingExcelLinkInstallWindowsandExcelbeforeyouinstallMATLABandExcelLink.ToinstallExcelLink,followtheinstructionsintheMATLABinstallationdocumentation.SelecttheExcelLinkcheckboxwhenyouselectMATLABcomponentstoinstall.ConfiguringExceltoWorkwit

6、hExcelLinkAfteryouhaveinstalledExcelLink,youarereadytoconfigureExcel.Youneeddothesestepsonlyonce:1.StartMicrosoftExcel.2.SelectTools>Add-InsandclickBrowse.3.FindandselecttheExcelLinkadd-inexcllink.xlaundermatlabroot/toolbox/exlink.ClickOK.（Throughoutthisdocumentthenotatio

7、nmatlabrootrepresentstheMATLABrootdirectory,thedirectorywhereMATLABisinstalledonyoursystem.）4.BackintheAdd-Insdialogbox,makesurethatthecheckboxisselectedandclickOK.TheExcelLinkadd-inloadsnowandwitheachsubsequentinvocationofExcel.5.WatchfortheappearanceoftheMATLABCommandWi

8、ndowbuttonontheWindowstaskbar.6.WatchfortheappearanceoftheExcelLinktoolbaronyourExcelworksheet.E