Mathematica Stack Exchange is a question and answer site for users of Mathematica. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I use Apple's Numbers spreadsheet for a single thing, a double entry accounting model to understand complicated financial transactions.

A current model depends on the value of a single initialization cell. I calculate this value in Mathematica using Solve[] as Numbers can't solve a system of equations. Currently I have to manually input this value in the Number's spreadsheet.

Ideally I'd like the cell in Number's to call the Mathematica function.

Does any means exist to do this?

Excel/Link or Math/Link would appear to provide functionality similar to this, but reading through their respective documentation doesn't provide any clear way to do this with Numbers.

I can write command-line code to do this (generally):

$ MathKernel -script file.m

which suggests that AppleScript or some other scripting language could do this if callable/runnable from Numbers.

Perhaps all of this suggests a better or more general question: What means exist, if any, for calling a Mathematica function or script from applications outside of Excel or specifically applications programmed for J/Link or Math/Link?

share|improve this question

closed as off-topic by Louis, MarcoB, m_goldberg, Öskå, Jens Jul 10 at 16:50

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "The question is out of scope for this site. The answer to this question requires either advice from Wolfram support or the services of a professional consultant." – Louis, MarcoB, m_goldberg, Öskå, Jens
If this question can be reworded to fit the rules in the help center, please edit the question.

I don't have Numbers but if you can use AppleScript to do things in Numbers then you can run the script from Mathematica – Mike Honeychurch Mar 31 '14 at 20:50