Maple and Excel - Maple Help

Online Help

All Products    Maple    MapleSim


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.

2. 

Click Add-ins.

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.

2. 

Click Add-ins.

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.

See Also

ExcelTools, ExcelTools[Export], ExcelTools[Import], Maple Versions


Download Help Document

Was this information helpful?



Please add your Comment (Optional)
E-mail Address (Optional)
What is ? This question helps us to combat spam