Hi there, I'm currently trying to use R in an automated macro with Excel, and to this effect I've been using the D(COM) server. However I've been having alot of problems with it, because it seems to be limited to only recieving and sending arrays. I've been struggling trying to find a way to receive model summaries from R to put in Excel. I also seem to have some strange errors coming up... I've tried doing everything I want directly in R by hand, and it has been fine, but excel seems to complicate everything :( Any people have suggestions? Thanks, joel
On Mon, 26 Jan 2004, Joel Pitt wrote:> Hi there, > > I'm currently trying to use R in an automated > macro with Excel, and to this effect I've been > using the D(COM) server. > > However I've been having alot of problems with > it, because it seems to be limited to only recieving > and sending arrays. I've been struggling > trying to find a way to receive model summaries > from R to put in Excel. I also seem to have > some strange errors coming up... > I've tried doing everything I want directly in R > by hand, and it has been fine, but excel seems to > complicate everything :( > > Any people have suggestions?There are two (D)COM servers for R, on by Thomas Baier that has its own mailing list, and one by Duncan Temple Lang (at omegahat.org and in the Omegahat area on CRAN). It is impossible for us to help with a message as vague as `some strange errors coming up', so I suggest you read chiark.greenend.org.uk/~sgtatham/bugs.html and then post on the appropriate mailing list for whichever server you are using. [The Baier-version list is listed at the bottom of its readme.txt file.] -- Brian D. Ripley, ripley at stats.ox.ac.uk Professor of Applied Statistics, stats.ox.ac.uk/~ripley University of Oxford, Tel: +44 1865 272861 (self) 1 South Parks Road, +44 1865 272866 (PA) Oxford OX1 3TG, UK Fax: +44 1865 272595
Hi Joel, You may want to take a look at the RDCOM implementation at omegahat.org/RDCOMServer. We've had very good experience with it. -- David Joel Pitt wrote:> Hi there, > > I'm currently trying to use R in an automated > macro with Excel, and to this effect I've been > using the D(COM) server. > > However I've been having alot of problems with > it, because it seems to be limited to only recieving > and sending arrays. I've been struggling > trying to find a way to receive model summaries > from R to put in Excel. I also seem to have > some strange errors coming up... > I've tried doing everything I want directly in R > by hand, and it has been fine, but excel seems to > complicate everything :( > > Any people have suggestions? > > Thanks, > joel > > ______________________________________________ > R-help at stat.math.ethz.ch mailing list > stat.math.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide! R-project.org/posting-guide.html