Maple and Excel
Maple is available as an add-in to Microsoft® Excel. This add-in is supported for Excel 2016, Excel 2013, and Excel 2010. 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 2016, Excel 2013, and Excel 2010 is available for 32-bit Windows and 64-bit Windows installations of Maple.
Enabling the Add-in for Excel
Using the Maple Excel Add-in
Copying from Excel to Maple
To enable the Maple Excel Add-in:
In Excel, click the File menu and select Options.
In the Manage box select Excel Add-ins, then click Go.
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.
Select the Maple Excel Add-in check box.
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.
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.
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:
Enable the add-in, if it is not already enabled.
View the Maple toolbar.
In Excel 2007, from the View menu, choose Toolbars, and then Maple.
In Excel 2016, 2013, or 2010, the toolbar is found under the Add-Ins tab.
On the Maple toolbar, click the question-mark button:
To copy cells from Excel to the Standard worksheet:
In Excel, select the cells you want to copy.
From the Edit menu, select Copy.
In Maple (Standard worksheet interface), place the cursor where you want to paste the contents.
From the Edit menu, select Paste. The cells are copied into Maple.
To copy cells from Excel to the Classic worksheet:
Click the Copy from Excel to Maple button.
In Maple's Classic worksheet interface, place the cursor where you want to paste the contents.
Download Help Document
What kind of issue would you like to report? (Optional)