search for: getarray

...plete an OLE action." There is no error in the RExcel commands in the macro, of that I am sure. The box appears to be related to the inclusion of RunRFile commands. The macro will run through the second RunRFile command, but will not execute the Worksheet.Pictures.Insert statements or the GetArray statements until the user clicks OK on the dialog box. Any insight into how I can avoid the dialog box would be appreciated. The macro is below. It's your basic, send-to-R, run R, retrieve-from-R macro. Call Rinterface.StartRServer Call Rinterface.RRun("rm(list = ls())") Call R...

...RRun("library(mdnn)") Call RInterface.RRun("F11b1<-read.table(""c:/test/Testb1.txt"", header=TRUE)") Call RInterface.RRun("passTestb1<-pass(Testb1, Threshold=5, ExtremeThreshold=5)") Call RInterface.RRun("passTestb1") Call RInterface.getArray("passTestb1", Range("D2")) Call RInterface.StopRServer end sub but I get an error : "unsupported data when trying to execute "passTestb1" I also tried: Dim x As StatConnector Set x = New StatConnector MsgBox ("Initializing R...") x.Init ("...

...m { /// ConstantBuilder - This provides a uniform API for creating constants. class ConstantBuilder { public: //===--------------------------------------------------------------------===// // Constant arrays //===--------------------------------------------------------------------===// /// GetArray - return a constant array given an array type and a vector /// of elements. static Constant *GetArray( const ArrayType *Ty, ///< The type of the array const std::vector<Constant*> &V) { ///< The elements of the array return ConstantArray::get(Ty, V);...

...t in my Excel file, which by means of VBA I read with RInterface.RunRCodeFromRange Range(...). Before this, I put Excel data to the required R variables with the RInterface.PutArray "...",Range(...). After the code is run, I want to get the variables from the code, which I want to do with GetArray. The model seems to work fine for small numbers of x, but with more than 5000 simulations, I get a VBA Run-time error '6', Overflow. The code works in R itself so I assume there is no problem in the code itself, but there is something wrong in the way VBA reads the code. Can someone help...

...003 -0.06756974 0.03893830 UrbanPop 0.04633575 0.97685748 -0.20054629 -0.05816914 Rape 0.07515550 0.20071807 0.97408059 0.07232502 I want to be able to do this because I am actually carrying out PCA in RExcel. I am able to do the PCA analysis using the "prcomp(data)" and "GetArray" commands, but doing that puts all of the aforementinoed output in a single row of cells instead of assigning each word and number its own individual cell. I figured this dealt more with R code than Excel, so I decided to post it here. Can anyone help me out? Is there a command that can car...

...ce.RRun "library(RODBC)" RInterface.RRun "A = odbcConnectExcel('c:/TRY.xls')" RInterface.RRun "q1 = sqlFetch(A, 'Sheet1')" RInterface.RRun "odbcClose (A)" Worksheets("out").Activate Call RInterface.GetArray("q1", Range("A1")) Call RInterface.StopRServer End Sub i have included four examples below. on the left hand side we have the data as it appears in Excel and on the right hand side we have the output from the code (outputted to the 'out' sheet in excel). in...

...req=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 >

some of you might be interested. i just uploaded the first release of my r-excel interface package to CRAN. it is in contributed extensions nonstandard extensions erich neuwirth -- Erich Neuwirth, Computer Supported Didactics Working Group Visit our SunSITE at http://sunsite.univie.ac.at Phone: +43-1-4277-38624 Fax: +43-1-4277-9386

some of you might be interested. i just uploaded the first release of my r-excel interface package to CRAN. it is in contributed extensions nonstandard extensions erich neuwirth -- Erich Neuwirth, Computer Supported Didactics Working Group Visit our SunSITE at http://sunsite.univie.ac.at Phone: +43-1-4277-38624 Fax: +43-1-4277-9386

...;B1") Elements = 100 ReDim DblArray(0 To Elements - 1) For i = 0 To Elements - 1 DblArray(i) = Rnd() Next i Start = Timer Call RInterface.StartRServer Call RInterface.PutArray("test", RngData) Call RInterface.RRun("z<-median(test)") Call RInterface.GetArray("z", RngData2) Call RInterface.StopRServer 'Range("B1") = RngData2 Length = Length + Timer - Start Debug.Print Length End Sub [[alternative HTML version deleted]]

...:$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. -- View this message in context: http://r.789695.n4.nabble.com/Usage-of-ETS-R-codes-through-RExcel-macros-in-VBA-tp4674292.html Sent from the R help mailing list archive at Nabble.com.

...ary(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) 20...

On Mon, Jul 21, 2014 at 3:48 PM, Manman Ren <manman.ren at gmail.com> wrote: > > > > On Mon, Jul 21, 2014 at 3:41 PM, David Blaikie <dblaikie at gmail.com> wrote: >> >> On Mon, Jul 21, 2014 at 3:35 PM, Manman Ren <manman.ren at gmail.com> wrote: >> > >> > >> > >> > On Mon, Jul 21, 2014 at 1:14 PM, David Blaikie

I wrote a R script say called computeCovarMatrix.R and i want to call and run this piece from Excel visual basic. does anyone know how to do that? thanks, KZ [[alternative HTML version deleted]]