This is not on topic for this mailing list. See the Statconn website for support for RExcel. --------------------------------------------------------------------------- Jeff Newmiller The ..... ..... Go Live... DCN:<jdnew...@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 <ruipbarra...@sapo.pt> wrote: >Hello, > >I must tell you once again to address your questions to > >r-help@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.ged...@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@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. ______________________________________________ R-help@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.