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

matlab与excel数据交换的有利工具——excel link(1) What Is Excel Link? Excel Link is a software add-in that integrates Microsoft Excel andMATLAB in a Microsoft Windows-based computing environment. By connecting Exceland MATLAB, you can access the numerical, computational, and graphical powerof MATLAB from Excel worksheet and macro programming tools. Excel Link letsyou exchange and synchronize data between the two environments. 1. System Requirements 2. Installing Excel Link 3. Configuring Excel to Work with Excel Link 4. Starting Excel Link 5. Connecting to an Existing MATLAB Session 6. Stopping Excel Link Follow these instructions to install Excel Link and then configure Excel. System Requirements Excel Link requires approximately 202 kilobytes of disk space. Operating system requirements are: Microsoft Windows XP ，Microsoft Windows 2000 Excel Link also requires one of the following versions of Excel: Excel 2000Excel ， 2002Excel ， 2003Excel（Excel Link has also been qualified against Excel 2007 Beta.） Excel Link also requires MATLAB for Windows. For best results with MATLAB figures and graphics, set the color palette of your display to a value greater than 256 colors. Click Start Settings Control Panel Display, and then click the Settings tab.Choose an appropriate entry from the Color Palette menu. Installing Excel LinkInstall Windows and Excel before you install MATLAB and Excel Link.To install Excel Link, follow the instructions in the MATLAB installation documentation. Select the Excel Link check box when you select MATLAB components to install. Configuring Excel to Work with Excel Link After you have installed Excel Link, you are ready to configure Excel. You need do these steps only once: 1. Start Microsoft Excel. 2. Select Tools Add-Ins and click Browse. 3. Find and select the Excel Link add-in excllink.xla under matlabroot/toolbox/exlink. Click OK.（Throughout this document the notation matlabroot representsthe MATLAB root directory, the directory where MATLAB is