How do I configure Spreadsheet Link EX (Excel Link) for use with Microsoft Office 2007?

3 views (last 30 days)
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.

Accepted Answer

MathWorks Support Team
MathWorks Support Team on 6 Sep 2018
Edited: MathWorks Support Team on 6 Sep 2018
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:

More Answers (0)

Categories

Find more on Data Export to MATLAB in Help Center and File Exchange

Tags

No tags entered yet.

Products

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!