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:

この項目は役に立ちましたか?
はい
いいえ

ご意見・ご提案がおありでしたらお書きください.

フィードバックをありがとうございました.

送信

サポートへのお問合せ

お支払い,アクティベーションに関する質問から技術的な質問まで,お気軽にお問い合せください.

販売代理店 (ライセンスをお持ちの方は、ご購入された代理店にお問い合わせください)

Hulinks

電話:03-5642-8380
Fax:03-5642-8381

soft.sales@hulinks.co.jp
Webサイト

日本電子計算株式会社

電話:03-5210-0184
Fax:03-5210-0229

math_info@cm.jip.co.jp
Webサイト

亘香通商株式会社

電話:045-320-2711
Fax:045-320-9342

sales@senko-corp.co.jp
Webサイト

株式会社シーエムディーラボ

電話:03-3408-8406
Fax:03-3408-8406

info@cmdlab.co.jp
Webサイト