How do I configure Spreadsheet Link EX (Excel Link) for use with Microsoft Office 2007?
조회 수: 8 (최근 30일)
이전 댓글 표시
MathWorks Support Team
2012년 9월 10일
편집: MathWorks Support Team
2018년 9월 6일
I would like information on setting up Spreadsheet Link EX to work with Microsoft Excel 2007. The instructions in the documentation are for Excel 2003 and no longer apply.
채택된 답변
MathWorks Support Team
2018년 9월 6일
편집: MathWorks Support Team
2018년 9월 6일
Follow these steps to install Spreadsheet Link EX with Microsoft Excel 2007:
1. Start Microsoft Excel.
2. Click the Microsoft Office Button, and then click Excel Options.
3. Click the Add-Ins category.
4. In the Manage box, select Excel Add-ins, and then click Go.
5. Click Browse.
6. Select the Excel Link add-in excllink.xla under $MATLABROOT/toolbox/exlink. (where $MATLABROOT is the MATLAB root directory on your machine, as returned by typing:
matlabroot
at the MATLAB command prompt.)
7. Click OK.
8. Back in the Add-Ins dialog box, make sure that the Excel Link check box is selected, and click OK. The Excel Link add-in loads now (and automatically loads with each subsequent invocation of Excel).
9. Watch for the appearance of the MATLAB button on the Windows taskbar.
10. Watch for the appearance of the "Add-Ins" menu item.
11. Click on the "Add-Ins" menu item. The Excel Link toolbar is displayed.
When installed and configured, the Spreadsheet Link EX and MATLAB software automatically start when you start a Microsoft Excel session and the MATLAB Command Window button appears on the Microsoft Windows taskbar.
The Spreadsheet Link EX add-in loads with each subsequent Excel session. The Add-Ins tab in Excel is now populated with seven pushbuttons called startmatlab, putmatrix, getmatrix, evalstring, getfigure, wizard and preferences. For further details, please refer to the following documentation link:
댓글 수: 0
추가 답변 (0개)
참고 항목
카테고리
Help Center 및 File Exchange에서 Data Import from MATLAB에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!