R help - Aug 2013 - Rexcel

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
>

This is not on topic for this mailing list. See the Statconn website for support
for RExcel.
---------------------------------------------------------------------------
Jeff Newmiller                        The     .....       .....  Go Live...
DCN:<jdnewmil at dcn.davis.ca.us>        Basics: ##.#.       ##.#.  Live
Go...
                                      Live:   OO#.. Dead: OO#..  Playing
Research Engineer (Solar/Batteries            O.O#.       #.O#.  with
/Software/Embedded Controllers)               .OO#.       .OO#.  rocks...1k
--------------------------------------------------------------------------- 
Sent from my phone. Please excuse my brevity.

Rui Barradas <ruipbarradas at sapo.pt> wrote:
>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
>>
>
>______________________________________________
>R-help at r-project.org mailing list
>https://stat.ethz.ch/mailman/listinfo/r-help
>PLEASE do read the posting guide
>http://www.R-project.org/posting-guide.html
>and provide commented, minimal, self-contained, reproducible code.