Wolfram Computation Meets Knowledge

How do I get started using Excel from Mathematica?

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 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.

<< ExcelLink` 

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.

Excel["A1"] = "hello" 

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.

g = Plot[Sin[a^2], {a, -3, 3}, PlotStyle -> Blue, Frame -> True, ImageSize -> 200]; 
Excel["B3"] = g 

Reading from an Excel sheet

Data from an Excel spreadsheet can be read into Mathematica using the Excel function and the range of addresses.

Excel["A2:A6"]

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 ExcelSave[] function.

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

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

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

送信

サポートへのお問合せ

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

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

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サイト