How do I install Mathematica Link for Excel?
Mathematica Link for Excel allows Mathematica to access spreadsheets open in Excel on the same computer and allows Excel macros to access Mathematica functions for calculations and graphics. It consists of a Wolfram Language package and an Excel plugin.
Mathematica Link for Excel is available only for Microsoft Windows operating systems. Installing the ExcelLink plugin requires that Excel already be installed on your machine.
- Locate the Link for Excel installer on your computer. If downloaded, it is likely in your Downloads folder under your user home directory.
- Right-click it and select Open. The Setup dialog opens.
- Click Install to begin installing the Wolfram Language package. The installation success window appears on your screen.
- Select Install/Update Excel Add-in and click Finish. The Link for Excel add-in installs, and the window closes.
Verifying the Package Installation
In a Mathematica notebook, enter and evaluate
<<ExcelLink`
No output is returned if the Wolfram Link for Excel package has been installed successfully.
Verifying the Excel Plugin Installation
- To start Excel with the add-in already active, navigate to Start ► All Programs ► Mathematica Link For Excel ► Mathematica Link Add-In.
- Move to the Home tab in Excel and type an “=EVAL( )” command with a Mathematica function and argument references in the function slot. The function evaluates automatically, and the output appears in the selected cell if the Excel add-in is properly installed.
