Maple and Excel
Maple is available as an add-in to Microsoft\302\256 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\302\256 only.
Enabling the Add-in for ExcelUsing the Maple Excel Add-inCopying from Excel to Maple
<Text-field style="Heading 2" layout="Heading 2" bookmark="bkmrk0">Enabling the Add-in for Excel</Text-field>
To enable the Maple Excel Add-in:
In Excel, click the File menu and select Options.
Click Add-ins.
In the Manage box select Excel Add-ins, then click Go.
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.
Select the Maple Excel Add-in check box.
Click OK.
<Text-field style="Heading 2" layout="Heading 2" bookmark="bkmrk1">Using the Maple Excel Add-in</Text-field>
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:
Enable the add-in, if it is not already enabled.
View the Maple toolbar, found under the Add-Ins tab.
On the Maple toolbar, click the question-mark button:P1RNR2M6QjpuSD4/Xj1WPUY6Qzo7SlJBWjpeckhKXFxLOjw6Oko6OztCWjtOOj1KOjxKOj9KPGI6Sjo9Slo9Vlo9Wjp2WXhJO2p5d1lCOnlheUU6eXl5eVE+XVI+XUI6Plo6PmtCRFxcOko6WkI8OjtKdl1SPl1COj46QlxcOko6WkI8Ojs6XFxCa0JcXEtWWkteQkA6QlxcRlxcQkBrSz5dQkBrQkA6QlxcRlxcQkxGQlxcOzpAckI8W0JGSktGXFxLRlxcOzpLVj5dQj55WTpdQlxcPks7OkA7O1I6XTpLTjpaO0Q+eWFSPktLTjpaOzxKPj86UlpaSz5LXFxSOlpCSEpZQnZdUj5rWkJAOlJaO1I6W3J5XFxLPj9LOzpAckF4eXl5eTpcXDtLTjpaO0A8eUl2XUJAS04+PzpSWjo+Szs6QHJCPFo7QkA+Szs6QEJAW1JCXFxLTjpaQlxcO0RcXD5LOzpcXEI6PjpCXFw6SjpaQjw6O0o+Q1xcOko6MzpcIlx7XH0=
<Text-field style="Heading 2" layout="Heading 2" bookmark="bkmrk2">Copying from Excel to Maple</Text-field>
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:
In Excel, select the cells you want to copy.
Click the Copy from Excel to Maple button.
In Maple's Classic worksheet interface, place the cursor where you want to paste the contents.
From the Edit menu, select Paste. The cells are copied into Maple.
See AlsoExcelToolsExcelTools[Export]ExcelTools[Import]Maple Versions