Wolfram Computation Meets Knowledge

How do I get started using Mathematica from Excel?

Mathematica Link for Excel enables you to share data and calculations between Mathematica and Microsoft Excel.

These instructions assume that Mathematica Link for Excel is downloaded and installed on your computer.

Here we showcase the first steps in connecting to Mathematica from Excel. For connecting to Excel from Mathematica, see here.

Advanced examples and information can be found in the Mathematica Link for Excel documentation.

Installing the Add-In in Excel

  1. Select Run All Programs ► Mathematica Link for Excel ► Mathematica Link Add-In. This installs the add-in.

  2. Select the ADD-INS tab.
  3. Verify that the Mathematica Link for Excel toolbar is present.

Mathematica Link for Excel is now installed in Excel.

Running a Mathematica Function in Excel

Enter calls to Mathematica in the cell content slot using the format:

=EVAL("FunctionName", arg1, arg2, ...)

In the following example, we compute the determinant of the matrix defined in cells A1 through B2.

Using the Function Wizard for Building Function Calls

The Mathematica Link for Excel toolbar contains a Function Wizard to help with more complicated Wolfram Language function calls in Excel.

To use the Function Wizard:

  1. Open the wizard by clicking the “fx” icon on the toolbar.
  2. Find the Wolfram Language function you wish to use. Click Next to confirm.
  3. Enter the arguments for the function. Click Next to confirm.
  4. If needed, alter any of the default options for the function. Click Enter to use the function.
  5. Enter the ID of the cell you want the output to appear in.

The output will then be placed in the specified cell:

该文档是否有帮助?

任何建议?

非常感谢您的反馈!

提交

联系支持团队

从账单到产品激活,以及任何技术相关内容,无论您遇到任何问题,我们都在此为您提供帮助。

1-800-WOLFRAM (+1-217-398-0700 美国境外用户)

客服支持

周一至周五
8am–5pm 美国中部时区

  • 产品注册或激活
  • 预售信息和订单
  • 安装帮助和首次启动

高级技术支持 (面向特定用户)

周一至周四
8am–7pm 美国中部时区

周五
8:30–10am & 11am–5pm 美国中部时区

  • 优先技术支持
  • Wolfram 专家助理专员
  • Wolfram 语言编程帮助
  • 高级安装支持