[R] R and DDE (Dynamic Data Exchange)

Gabor Grothendieck ggrothendieck at gmail.com
Tue Jul 18 16:27:49 CEST 2006

You can access DDE via COM as in this example
which uses DDE to open an Excel file.  Note that
Excel also supports COM directly and normally
one would use COM with Excel, not DDE, so you
might check if your application also supports COM.

# opens an excel spreadsheet c:\test.xls using dde
sh <- COMCreate("Shell.Application")

Also if you are going to access DDE via COM or just COM also
check out the rcom package which is similar to RDCOMClient.

On 7/17/06, vincent at 7d4.com <vincent at 7d4.com> wrote:
> R and DDE (Dynamic Data Exchange)
> Dear Rusers,
> I run an application (not mine) which acts as a DDE server.
> I would like to use R to get data from this application,
> say once per minute, and do some processing on it.
> I didn't find much info on the R DDE abilities, apart the tcltk2
> package in which I will try to go deeper.
> I would be very thankful for any info, pointer or advice about the
> "good ways" to make R program get online data from a DDE server.
> Thanks
> Vincent
> ______________________________________________
> R-help at stat.math.ethz.ch mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html

More information about the R-help mailing list