[R] Usage of ETS R codes through RExcel macros in VBA

[Siddharth]

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 output table at the end of the code from RExcel to
Excel using Rexcel Macros?

Other option I have tried is:

Rinterface.getarray “etszP”, Range(“Sheet1!Z1”)
The output in this case is not in the desired format.





--
View this message in context: http://r.789695.n4.nabble.com/Usage-of-ETS-R-codes-through-RExcel-macros-in-VBA-tp4674292.html
Sent from the R help mailing list archive at Nabble.com.