search for: runrcodefromrange

...R-code which I made in R at first and now I am trying to transform it into excel. The R code is a simulation of a random path x times, put into matrices and then doing some transformations on it. I pasted the R code on a seperate sheet in my Excel file, which by means of VBA I read with RInterface.RunRCodeFromRange Range(...). Before this, I put Excel data to the required R variables with the RInterface.PutArray "...",Range(...). After the code is run, I want to get the variables from the code, which I want to do with GetArray. The model seems to work fine for small numbers of x, but with more than...

...clerx.com escreveu: > Hi Rui thanks a lot for your reply for my previous query, was of great help to me. I am facing one last query on the following given issue. > > Issue: > Usage of ETS R codes through RExcel macros in VBA > > Given below is my command code: > > Rinterface.runrcodefromrange Range(?Sheet1!B2:D8?) > > Following are the codes written in the given cell reference: > > #!rput zz 'Sheet1'!$B$2:$B$22 > library(forecast) > zz <- ts(zz,freq=365,start=c(2009,1)) > etsz <- ets(zz,model='AAN') > etszP <- forecast(etsz,h=34) > wr...

Issue: Usage of ETS R codes through RExcel macros in VBA Given below is my command code: Rinterface.runrcodefromrange Range(?Sheet1!B2:D8?) Following are the codes written in the given cell reference: #!rput zz 'Sheet1'!$B$2:$B$22 library(forecast) zz <- ts(zz,freq=365,start=c(2009,1)) etsz <- ets(zz,model='AAN') etszP <- forecast(etsz,h=34) write.table(etszP) How can I import the outp...

*Issue:* Usage of ETS R codes through RExcel macros in VBA Given below is my command code: Rinterface.runrcodefromrange Range(“Sheet1!B2:D8”) Following are the codes written in the given cell reference: #!rput zz 'Sheet1'!$B$2:$B$22 library(forecast) zz <- ts(zz,freq=365,start=c(2009,1)) etsz <- ets(zz,model='AAN') etszP <- forecast(etsz,h=34) *write.table(etszP)* How can I i...