Maple and Excel

Maple is available as an addin to Microsoft® Excel. This addin is supported for Excel 2013, Excel 2010, and Excel 2007. Refer to ExcelTools for information on the nonaddin based package for importing and exporting data from Excel spreadsheets. The following is a description of the Maple Excel addin 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 addin is available for Maple on Windows®. The Excel addin for Excel 2013 and Excel 2010 is available for 32bit Windows and 64bit Windows installations of Maple. However, the Excel addin for Excel 2007 is only available for the 32bit installation of Maple. To use the Excel addin, you must use a Maple version that was installed using the 32bit Windows® installer. For more information, see the Install.html file on your product disc.


Enabling the Addin for Excel



Enabling the Addin for Excel 2013 or 2010


To enable the Maple Excel Addin:
1.

Click the File menu and select Options.

3.

In the Manage box select Excel Addins, then click Go.

4.

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

–

For 32bit Windows, select WMIMPLEX.xla (that is, select $MAPLE/Excel/WMIMPLEX.xla), and click OK.

–

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

5.

Select the Maple Excel Addin check box.



Enabling the Addin for Excel 2007


To enable the Maple Excel Addin:
1.

Click the Microsoft Office Button and select Excel Options.

3.

In the Manage box select Excel Addins, 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 Addin check box.




Using the Maple Excel Addin


•

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 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 addin, 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 AddIns tab.

3.

On the Maple toolbar, click the questionmark 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.


