[R] I need help integrating ggplot2 into Excel

[Felipe Carrillo]

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 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.
> 


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