I'm wondering if it is possible to link Excel and Mathematica in real time, so that Mathematica can be used as a computing and "storage" tool. Suppose I have an Excel spreadsheet with an active DDE link:
I would like to know if it is possible for Mathematica to communicate with Excel in real time and store every cell update in Excel. I know there is a package called ExcelLink, with several functions to link Mathematica and Excel. So, if I use, for instance ExcelRead["A2"]
I get the correct value
19.36
However, it is not dynamic! I can get dynamic values by using
a=Dynamic[Refresh[ExcelRead["A2"], UpdateInterval -> 0]]
b=Dynamic[Refresh[ExcelRead["B2"], UpdateInterval -> 0]]
However, when I try to add a+b
I get
19.36+28.56
And, worse, If I use
Dynamic[a+b, UpdateInterval -> 0]
I get
19.36+28.56
So, here arises my first problem: although Mathematica reads the values in real time from Excel, I'm not able to perform any calculation with them. Is there any way to do it?
My second problem is: how can I write dynamically the values I'm getting from the DDE Link inside Excel itself? I need to write every updated value in Excel in a sequence like shown below
Dynamic
objects! $\endgroup$a
andb
you have in Mathematica have the headDynamic
, for which the operation+
is not defined. What doesDynamic[Setting@a + Setting@b, ...]
give? $\endgroup$UpdateInterval -> 0
? Can't you do it slower? What's the point in updating like crazy if you don't need to? You'll quickly run out of memory at this rate... $\endgroup$