Re: [R] I need help integrating ggplot2 into Excel

From: Felipe Carrillo <mazatlanmexico_at_yahoo.com>
Date: Thu, 20 Mar 2008 20:37:45 -0700 (PDT)


Create an R script,name it "Myggplot2" and place it on your desktop.In excel open the vb editor and write this code:
Sub Myggplot2()
'start R
Call rinterface.StartRServer
'Put the dataframe into R,assuming that your 'data is in sheet1 cells A1:D1
Call rinterface.PutDataframe("yourdataframename", Range("Sheet1!A1:D" & Range("D1").End(xlDown).Row)) Call rinterface.RRun("attach(yourdataframename)") 'dataframe is attached,now run r script
rinterface.RRun "source(""C:/Documents and Settings/Owner/Desktop/Myggplot2.r"")"
Call rinterface.StopRServer
End Sub

Running code from RExcel you must use print(myplot)at the end of the code
good luck

>
> Dear all
>
> I use ggplot2 extensively for my plotting routines
> and rexcel to have the
> best of two worlds. (RExcel v 1.75 and R (D)Com v.
> 2.5)
>
> I can run my ggplot functions, such as qplot(...),
> in scratchpad mode, but
> not in Macro nor Worksheet functions mode.
>
> I have tried the following in Macro mode:
>
> Call RInterface.RRun("library(ggplot2)")
> ...
> Call
>
RInterface.RRun("qplot(x=Hours,y=pH,data=ds,facets=Sample~.,geom=""line"",group=Cell)")
>
> With no output ...
>
> I have tried the following in Worksheet function
> mode:
>
> if Range(H40:I42) contains:
> "
> (Embedded image moved to file: pic10654.jpg)
> "
> and Range(H48) contains:
>
> "qplot"
>
> The following call:
>
> =Rcalla(H48;makeargs(H40:I42))
>
> Gives me no output
>
> Scratchpad mode
>
> However, right clicking a cell containing:
>
qplot(x=Hours,y=pH,data=ds,facets=Sample~.,geom=""line"",group=Cell)
> and then selecting "Run R" works like a dream!
>
> I would like to develop an excel based GUI for
> R-data treatment and
> plotting, and I would like to use ggplot2 as my
> plotting engine.
>
> What am I doing wrong?
>
> Thank you for your help
>
> Jannik VindelÝv, Ph.D.
> Project Manager
> Dairy Culture Development
> Innovation
>
> P.O. Box 64
> Arpajon
> Cedex
> F-91292
> France
>
> Phone: +33 (0)1 6988 3636
> Direct Phone: +33 (0)1 6988 3629>



> R-help@r-project.org 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.
>

 Felipe D. Carrillo
  Fishery Biologist
  Department of the Interior
  US Fish & Wildlife Service
  California, USA



R-help_at_r-project.org 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 Fri 21 Mar 2008 - 03:42:20 GMT

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.2.0, at Fri 21 Mar 2008 - 06:30:24 GMT.

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

list of date sections of archive