Uma Sitaraman wrote:
> Hi,
>
>
>
> I am new to both R and RDcom, and am stuck trying to read excel data
> using R (through VBA code). I tried out the test code posted in the web
> (given below)
>
>
>
> Sub ReadTest()
>
>> rinterface.StartRServer
>
>> rinterface.RRun "setwd(""c:
Hope this helps:
Sub MyMACRO()
Call rinterface.StartRServer
'Put the dataframe into R
Call rinterface.PutDataframe("dataframeName",
Range("Sheet1!A1:D" & Range("D1").End(xlDown).Row))
Call rinterface.RRun("attach(dataframeName)")
Call rinterface.StopRServer
> I am new to both R and RDcom, and am
Hi,
I am new to both R and RDcom, and am stuck trying to read excel data
using R (through VBA code). I tried out the test code posted in the web
(given below)
Sub ReadTest()
> rinterface.StartRServer
> rinterface.RRun "setwd(""c:/work/rcomtest"")"
> ChDir "c:\work\rcomtest"
>