2.5.3

Enable JavaScript to interact with content and submit forms on Wolfram websites. Learn how

Working in Mathematica

Creating Excel Functions

Code Box Deployment

Once you have developed a set of Mathematica functions you would like to use in Excel, you can collect cells that define the functions in one place to make it easier to transfer the code to Excel.

To deploy this code as an Excel function, you will need to copy the contents of the notebook cells that define the function to an initialization code box in an Excel workbook.

Here is how to do this.

1. Create an initialization code box in Excel:

• Click Macros on the Mathematica Toolbar.

• Click New... and name the macro Initialization. This is the default if no other macros exist in your workbook.

• Select a location for the code box and click OK.

2. Copy the code from Mathematica:

Show In/Out Names to temporarily hide input labels.

• Select the Input cells to copy. To select noncontiguous cells, hold down the Control key.

• Press Crtl-C or choose Edit

3. Paste the Mathematica code into the Excel code box:

• Click inside the code box.

• Click and drag to select all existing contents of the code box.

• Press Delete to delete the previous contents.

• Press Ctrl-V or choose {Edit , XMLElement[img, {src -> /chars/RightTriangle.gif, width -> 8, height -> 19, align -> absmiddle}, {}], Paste.}

You can now use the Mathematica function you created inside Excel.

• Using the code box approach, you can create workbooks that have no dependencies on other files.