Mathematica Link for Excel enables you to share data and calculations between Mathematica and Microsoft Excel.
Here we showcase the first few steps in using ExcelLink to connect to Excel from Mathematica. For connecting to Mathematica from Excel, see here.
Advanced information can be found in the Mathematica Link for Excel documentation.
Connecting ExcelLink to Mathematica
To start using the link from inside Mathematica, load the ExcelLink package.
This loads a library of functions and symbols into Mathematica.
Writing Text or Data to an Excel Sheet
Assign the value to the
Excel function with the Excel cell ID as the argument. This puts the string
"hello" in cell A1 in the active spreadsheet.
Placing a Graphic in Excel
This creates a graphic in Mathematica and assigns it to a cell. The upper-left corner of this plot appears in cell B3.
Reading from an Excel sheet
Data from an Excel spreadsheet can be read into Mathematica using the
Excel function and the range of addresses.
Note that numerical data is read as floating-point (real) numbers.
Saving an Excel Sheet
Changes in an Excel spreadsheet can be saved from Mathematica using the
Whether you have a question about billing, activation or something more technical, we are ready to help you.
1-800-WOLFRAM (+1-217-398-0700 for international callers)
8am–5pm US Central Time
- Product registration or activation
- Pre-sales information and ordering
- Help with installation and first launch
Advanced Technical Support (for eligible customers)
8am–7pm US Central Time
8:30–10am & 11am–5pm US Central Time
- Priority technical support
- Product assistance from Wolfram experts
- Help with Wolfram Language programming
- Advanced installation support