Hello,
I must tell you once again to address your questions to
[email protected]
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, [email protected] 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
______________________________________________
[email protected] 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.
