[R] Rexcel

[Rui Barradas]

Hello,

I must tell you once again to address your questions to

r-help at r-project.org

And since there was no subject line, I've made up one.

Your question seems to be a question about excel, and I really can't 
help you. Maybe someone else can.
But if you write.table(etszP) can't you read that file into excel?

Rui Barradas

Em 22-08-2013 15:57, siddhartha.geddam at eclerx.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)
> 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.
>
>
> _____________________________________
> Sent from http://r.789695.n4.nabble.com
>