Re: [R] R and DDE (Dynamic Data Exchange)

From: Gabor Grothendieck <ggrothendieck_at_gmail.com>
Date: Wed 19 Jul 2006 - 00:27:49 EST

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 library(RDCOMClient)
sh <- COMCreate("Shell.Application")

sh$Namespace("C:\\")$ParseName("test.xls")$InvokeVerb("&Open")

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@7d4.com <vincent@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@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
>



R-help@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 and provide commented, minimal, self-contained, reproducible code. Received on Wed Jul 19 01:49:43 2006

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.1.8, at Wed 19 Jul 2006 - 20:16:49 EST.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.