*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]]

