[R] Statconnector and Excel

Erich Neuwirth erich.neuwirth at univie.ac.at
Thu Mar 7 15:01:57 CET 2002

i cannot diagnose you problem completely because i do not know
what kind or result your function pass returns and therefore
what kind of object passTestb1 is.

the current version of my vba interface

needs matrices.

if your result is not a matrix, but "compatible" with the
matrix type, then
Call RInterface.getArray("as.matrix(passTestb1)", Range("D2"))
should work.

Call RInterface.RRun("passTestb1")
is definitely a bbad idea except when
pass created a function as its return value.

nolwennlm at netcourrier.com wrote:

> Hi,
> I'm trying to combine a VBA macro and a R package. I've installed the R-(D)COM and the R-excel interface by Neuwirth. They seem to work both. However I would like to display the r-generated data in  an Excel sheet as an array but I don't manage.
> Here is an example of my source:
> Sub doR()
> Call RInterface.StartRServer
> Call RInterface.RRun("library(mdnn)")
> Call RInterface.RRun("F11b1<-read.table(""c:/test/Testb1.txt"", header=TRUE)")
> Call RInterface.RRun("passTestb1<-pass(Testb1, Threshold=5, ExtremeThreshold=5)")
> Call RInterface.RRun("passTestb1")
> Call RInterface.getArray("passTestb1", Range("D2"))
> Call RInterface.StopRServer

> end sub

Erich Neuwirth, Computer Supported Didactics Working Group
Visit our SunSITE at http://sunsite.univie.ac.at
Phone: +43-1-4277-38624 Fax: +43-1-4277-9386

r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html
Send "info", "help", or "[un]subscribe"
(in the "body", not the subject !)  To: r-help-request at stat.math.ethz.ch

More information about the R-help mailing list