*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 i.e not in the form of
a table, the values are displayed horizontally separated by commas, making
it possible to separate them even with a delimiter.
--
Regards,
G.Siddharth
Phone: +91 8698902787
MBA (Marketing) 2011-13*
**SCMHRD** | Symbiosis Centre for Management and Human Resource Development*
--
*Disclaimer: The information contained in this e-mail message is intended
only for the use of the individual or entity to which it is addressed. If
you are not the intended recipient, you should return it to the sender
immediately. Any review, retransmission, dissemination or other use of, or
taking of any action in reliance upon, this information by persons or
entities other than the intended recipient is prohibited, and all liability
arising therefore is disclaimed. If you received this in error, please
contact the sender and delete the material from any computer. Please note
that while we scan all e-mails for viruses we cannot guarantee that any
e-mail is virus-free and accept no liability for any damage caused by any
virus transmitted by this email. Please be aware that the entire content of
this e-mail and replies to it may be monitored by the sender's institution
for quality assurance, policy compliance and/or security purposes.*
* *
[[alternative HTML version deleted]]
