search for: rinterfac

...nd, but will not execute the Worksheet.Pictures.Insert statements or the GetArray statements until the user clicks OK on the dialog box. Any insight into how I can avoid the dialog box would be appreciated. The macro is below. It's your basic, send-to-R, run R, retrieve-from-R macro. Call Rinterface.StartRServer Call Rinterface.RRun("rm(list = ls())") Call Rinterface.RRun("dev.off()") Call Rinterface.PutArray("mat1", Range("DATA_INPUT_OUTPUT!B7:I506")) Call Rinterface.PutArray("mat2", Range("DATA_INPUT_OUTPUT!J7:Q506"))...

...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("pas...

...e some binary .dmg packages to install easly rpy under mac os x? I'm tryin' to install Rpy under Mac Os X but I receive the following message: host46-209-dynamic:rpy usernone$ python setup.py install running install running build running build_py running build_ext building 'rpy2.rinterface.rinterface' extension gcc -arch ppc -arch i386 -isysroot /Developer/SDKs/MacOSX10.4u.sdk - fno-strict-aliasing -Wno-long-double -no-cpp-precomp -mno-fused-madd - fno-common -dynamic -DNDEBUG -g -O3 -DR_INTERFACE_PTRS=1 - DCSTACK_DEFNS=1 -DRIF_HAS_RSIGHAND=1 -I/Library/Frameworks/R.framewor...

...ot. data is X                  Y(1)             Z(1) 1-jan-02       2002        number 2-jan-02       2002        number . . . 1-jan-03       2003 (Y2)     number Z(2) 2-jan-03       2003 (Y2)     number Z(2) . . . until dec 31 2007.   I used the plot3d funtions to build a scatter point plot. Call rinterface.rrun("library(rgl)") Call rinterface.rrun("plot3d(x,y1,z1,xlab='Date',ylab='Year',zlab='Vol',ylim=c(2001,2008))") Call rinterface.rrun("plot3d(x,y2,z2,add=TRUE)") Call rinterface.rrun("plot3d(x,y3,z3,add=TRUE)") Call rinterface.rrun(&...

Hi, I was recently pointed out that a definition in Rinterface.h can be conflicting with a definition in stdint.h: /usr/include/R/Rinterface.h has: typedef unsigned long uintptr_t; /usr/include/stdint.h has: typedef unsigned int uintptr_t; (when 32bit platform complete definition is: #if __WORDSIZE == 64 # ifndef __intptr_t_defined typedef long int...

...R script with in excel using VBA. My VBA code is shown bellow. The middle section of this mail also includes the content of my Rscript. The bottom part shows the error message form the R console. It seems that Excel is opening the R console without any problems. The problem I am seeing is that Rinterface.RRun instruction is interpreting the "\T" part of the path as an R command. It does not recognize the "X:\Trading\Energy\JorgeSpace\TMPholder\cpixe\home models\" as a one single string, or path. Any ideas how can I fix the problem? Thanks ,' Jorge VB code Sub tester(...

hello all i have a quick question. i have been using the RODBC library (trying to read Excel data into R but i am doing this by using Rexcel. this is probably not the correct forum - sorry for this). my code is shown below: Sub A() 'start the connection to R Call RInterface.StartRServer RInterface.RRun "library(RODBC)" RInterface.RRun "A = odbcConnectExcel('c:/TRY.xls')" RInterface.RRun "q1 = sqlFetch(A, 'Sheet1')" RInterface.RRun "odbcClose (A)" Worksheets("out").Ac...

On 29/12/2016 15:55, Simon Urbanek wrote: > The problem is elsewhere - Rinterface.h guards the ultima-ratio fallback with HAVE_UINTPTR_T but that config flag is not exported in Rconfig.h. Should be now fixed in R-devel - please check if that works for you. Rconfig.h would be appropriate if Rinterface.h is being included from C code using the same compiler as used for R. But...

> On Jan 1, 2017, at 5:12 PM, Laurent Gautier <lgautier at gmail.com> wrote: > > > > 2017-01-01 8:28 GMT-05:00 Prof Brian Ripley <ripley at stats.ox.ac.uk>: > On 29/12/2016 15:55, Simon Urbanek wrote: > The problem is elsewhere - Rinterface.h guards the ultima-ratio fallback with HAVE_UINTPTR_T but that config flag is not exported in Rconfig.h. Should be now fixed in R-devel - please check if that works for you. > > Rconfig.h would be appropriate if Rinterface.h is being included from C code using the same compiler as used for...

The problem is elsewhere - Rinterface.h guards the ultima-ratio fallback with HAVE_UINTPTR_T but that config flag is not exported in Rconfig.h. Should be now fixed in R-devel - please check if that works for you. Thanks, Simon > On Dec 26, 2016, at 11:25 PM, Laurent Gautier <lgautier at gmail.com> wrote: > > Hi, &g...

2017-01-01 8:28 GMT-05:00 Prof Brian Ripley <ripley at stats.ox.ac.uk>: > On 29/12/2016 15:55, Simon Urbanek wrote: > >> The problem is elsewhere - Rinterface.h guards the ultima-ratio fallback >> with HAVE_UINTPTR_T but that config flag is not exported in Rconfig.h. >> Should be now fixed in R-devel - please check if that works for you. >> > > Rconfig.h would be appropriate if Rinterface.h is being included from C > code usin...

...ful) to find out how to pass directly VBA array into R Below an example - sorry it is VBA - including a very simple call to R >> The below code function perfectly, my question is: How could I pass directly DblArray into R variable "test" >> So it would be something like: Call RInterface.PutArray("test", DblArray) >> But as could be expected I have an error because the RInterface.PutArray() is expecting an Excel range as second argument Any hint very appreciated! Thanks & regards, Julien Cuisinier Sub Demo1() Dim i As Long D...

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

...2 -I/usr/include/R -I/usr/local/include -fpic -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector --param=ssp-buffer-size=4 -m32 -march=i386 -mtune=generic -fasynchronous-unwind-tables -I. -g `pkg-config --cflags protobuf` -Wall -c display.cc -o display.o /usr/include/R/Rinterface.h:84: error: conflicting declaration 'typedef long unsigned int uintptr_t' /usr/include/stdint.h:129: error: 'uintptr_t' has a previous declaration as 'typedef unsigned int uintptr_t' display.cc includes a header file ream.h which has #ifndef __ream_h #define __ream_h #...

...TIFY_SOURCE=2 -fstack-protector -funwind-tables -fasynchronous-unwind-tables -g -DNDEBUG -DPACKAGE_VERSION=\"0.6\" -DINTERNAL_ARPACK -DIGRAPH_THREAD_LOCAL=/**/ -fpic -fmessage-length=0 -O2 -Wall -D_FORTIFY_SOURCE=2 -fstack-protector -funwind-tables -fasynchronous-unwind-tables -g -c rinterface.c -o rinterface.o rinterface.c:30:15: fatal error: R.h: File or directory does not exist! compilation terminated. make: *** [rinterface.o] Error 1 ERROR: compilation failed for package ?igraph? * removing ?/usr/lib64/R/library/igraph? The downloaded source packages are in ?/tmp/RtmpSFsTPv/down...

...UnsatisfiedLinkError: no jri in java.library.path at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1682) at java.lang.Runtime.loadLibrary0(Runtime.java:823) at java.lang.System.loadLibrary(System.java:1030) at org.rosuda.JRI.Rengine.<clinit>(Rengine.java:9) at net.datenanalyse.iedae.rinterface.RInterface.<init>(RInterface.java:20) at net.datenanalyse.iedae.rinterface.Start.main(Start.java:9) Java Result: 1 ----------------- OK, we know that we have same .dll reference problems. In the first step we copied all necessary .dlls into the system32 folder and checked that we fix all...

Dear R-help, Call RInterface.StartRServer ' Works fine Call RInterface.RRun("objects()") ' Works fine Call Rinterface.RRun( other R commands which do not generate errors, the demos etc ) ' Works fine But ... Call RInterface.RRun("doesnotexist") ' Sends Excel into endless loop it ap...

Hi, I'm using R-2.8.1 for windows. I wrote a script calls the RODBC package to run sql queries against an oracle database. It runs fine when run from the rconsole and returns a data.frame with a summary for a set of experiments. I want to run this script using the rinterface.RunRFile command in an excel plugin, using the rexcel package. When I run the code from my excel plugin I get an error: "Error -2147220502 in Module RExcel.RServer Error running expression eval(parse(text="source(.rexcel..hzpouai)"))" Here is my excel plugin code:...

...mation. > >>> import rpy2.robjects as robjects > Traceback (most recent call last): > File "<stdin>", line 1, in <module> > File "/usr/local/lib64/python2.7/site-packages/rpy2/robjects/__init__.py", > line 12, in <module> import rpy2.rinterface as rinterface > File > "/usr/local/lib64/python2.7/site-packages/rpy2/rinterface/__init__.py", > line 66, in <module> from rpy2.rinterface.rinterface import * > ImportError: /usr/lib64/R/lib/libRlapack.so: undefined symbol: > _gfortran_concat_string -----------------...

Hello thankful R friends, Can I use iteration (for) or conditional (if) syntax in rexcel using rrun? I've finished coding my program and want to run through Excel. I just want to run such as Call rinterface.RRun("for(i in 1:10){") Call rinterface.RRun("a[i,1]<-i") Call rinterface.RRun("}") But it doesn't work. Any solution or trick to use "for" or "if" syntax? Thanks in advance as always, Dong-Joon [[alternative HTML version deleted]]