[R] Statconnector and Excel
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
if your result is not a matrix, but "compatible" with the
matrix type, then
Call RInterface.getArray("as.matrix(passTestb1)", Range("D2"))
is definitely a bbad idea except when
pass created a function as its return value.
nolwennlm at netcourrier.com wrote:
> 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