Excel Add-In - Maple Help
For the best experience, we recommend viewing online help using Google Chrome or Microsoft Edge.

Online Help

All Products    Maple    MapleSim


Home : Support : Online Help : Connectivity : Excel Add-In

Maple and Excel

  

Maple is available as an add-in to Microsoft® Excel. This add-in is supported for Excel 365 (desktop) and Excel 2019. Refer to ExcelTools for information on the non-add-in based package for importing and exporting data from Excel spreadsheets. The following is a description of the Maple Excel add-in features.

• 

Access to Maple commands from within Excel

• 

Ability to copy and paste between Maple and Excel

• 

Access to a subset of the Mathematics section of the Maple help system

• 

Maple Function Wizard to step you through the creation of a Maple function call

  

Note: The Excel add-in is available for Maple on Windows® only.

 

Enabling the Add-in for Excel

Using the Maple Excel Add-in

Copying from Excel to Maple

Enabling the Add-in for Excel

To enable the Maple Excel Add-in:

1. 

In Excel, click the File menu and select Options.

2. 

Click Add-ins.

3. 

In the Manage box select Excel Add-ins, then click Go.

4. 

Navigate to the Excel subdirectory of your Maple installation and select the file:

– 

WMIMPLEX64.xla (that is, select $MAPLE/Excel/WMIMPLEX64.xla), and click OK.

5. 

Select the Maple Excel Add-in check box.

6. 

Click OK.

Using the Maple Excel Add-in

• 

To get started accessing Maple from Excel, type the following basic formula in cell A1.  This will connect to Maple and compute the result, 2*x, which will be displayed as the value for cell A1.

  

=maple("x+x")

• 

Now, in cell A2, enter the following formula.  The placeholder &1 is filled in with the value of the cell reference supplied as the second argument.  The result of this formula will be 8*x^3.

  

=maple("(&1)^3", A1)

• 

In cell A3, enter a formula that references a range of cells. The multiple cell grouping will be put into a Maple list of lists. Wrapping the Matrix command around &1 will cause a Matrix to be created with the given data. This statement assigns the matrix to the variable, M, which can be referenced now from any other cell formula in Excel. Use a colon instead of a semicolon to avoid displaying the resulting value.

  

=maple("M := Matrix(&1);", A1:A2)

• 

Finally, reference the individual elements of the matrix as needed. The following formula in cell A4 will yield the value 8*x^3+2*x.

  

=maple("M[1,1] + M[2,1]")

• 

More information is available in the Using Maple in Excel online help file within Excel.  To view this help file:

1. 

Enable the add-in, if it is not already enabled.

2. 

View the Maple toolbar, found under the Add-Ins tab.

3. 

On the Maple toolbar, click the question-mark button:

Copying from Excel to Maple

To copy cells from Excel to Maple:

1. 

In Excel, select the cells you want to copy.

2. 

From the Edit menu, select Copy.

3. 

In Maple (Standard worksheet interface), place the cursor where you want to paste the contents.

4. 

From the Edit menu, select Paste. The cells are copied into Maple.

See Also

ExcelTools

ExcelTools[Export]

ExcelTools[Import]

Maple Versions