Maple and Excel - Maple Programming Help

Home : Support : Online Help : Connectivity : Excel

Maple and Excel

 Maple is available as an add-in to Microsoft® Excel. This add-in is supported for Excel 2013, Excel 2010, and Excel 2007. 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®. The Excel add-in for Excel 2013 and Excel 2010 is available for 32-bit Windows and 64-bit Windows installations of Maple.  However, the Excel add-in for Excel 2007 is only available for the 32-bit installation of Maple.  To use the Excel add-in, you must use a Maple version that was installed using the 32-bit Windows® installer. For more information, see the Install.html file on your product disc.

Enabling the Add-in for Excel

Enabling the Add-in for Excel 2013 or 2010

To enable the Maple Excel Add-in:

 1 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 appropriate file:
 – For 32-bit Windows, select WMIMPLEX.xla (that is, select $MAPLE/Excel/WMIMPLEX.xla), and click OK.  – For 64-bit Windows, select WMIMPLEX64.xla (that is, select$MAPLE/Excel/WMIMPLEX64.xla), and click OK.
 5 Select the Maple Excel Add-in check box.
 6 Click OK.

Enabling the Add-in for Excel 2007

To enable the Maple Excel Add-in:

 1 Click the Microsoft Office Button and select Excel Options.
 3 In the Manage box select Excel Add-ins, then click Go.
 4 Navigate to the Excel subdirectory of your Maple install and select WMIMPLEX.xla (that is, select \$MAPLE/Excel/WMIMPLEX.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 semi-colon 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.
 – In Excel 2007, from the View menu, choose Toolbars, and then Maple.
 – In Excel 2010 or 2013, the toolbar is 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.