Excel Add-In - Maple Help

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 2019 and Excel 2016. 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

To enable the Maple Excel Add-in:

 1 In Excel, click the File menu and select Options.
 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 the Standard worksheet:

 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.

To copy cells from Excel to the Classic worksheet:

 1 In Excel, select the cells you want to copy.
 2 Click the Copy from Excel to Maple button.
 3 In Maple's Classic 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.