similar to: Issue with installing RExcel

Hello, I just installed RExcel but I have some problems. I am writing you the set of commands that I used: > install.packages("RExcelInstaller", "rcom", "rsproxy") > library(rcom) > comRegisterRegistry() > library(RExcelInstaller) > installstatconnDCOM() > installRExcel() But when I select RStart from add-ins I see this written "No R server

Hola a todos, Mi nombre es Juanjo. Llevo un tiempo intentado hacer funcionar un programa que necesita de la instalación de RPROJECT y REXCEL. He mirado varias guías e instalado los programas pero obtengo varios errores. El principal es que tras instalar RProject, Rexcel y statcon y al intentar correr esta macro desde Visual Basic… Sub Start() RInterface.StartRServer

Hi, I am installing Excel using package "RExcelInstaller". When I tried to run installRExcel() I got this error message: You don not have the R package rcom installed. The (D)COM server installed which will aloow you to use the background server in RExcel. Since rcom is not installed, foreground mode will be unavailable. You may continue with the installation, but in most

Struggled a whole day, but still could not get DCOM working on my machine. What I did is: 1. Installed R 2.8.1 under folder "../R/R-2.8.1" 2. Installed R_Scilab_DCOM3.0-1B5 under folder ".. \R\(D)COM Server" 3. Installed packages: rscproxy_1.0-12, RExcelInstaller_3.0-10, rcom_2.0-4... 4. run the following commands: library(rscproxy) library(rcom)

Hi, I am running a test to call an R script with in excel using VBA. My VBA code is shown bellow. The middle section of this mail also includes the content of my Rscript. The bottom part shows the error message form the R console. It seems that Excel is opening the R console without any problems. The problem I am seeing is that Rinterface.RRun instruction is interpreting the "\T"

I have followed the instructions according to: http://rcom.univie.ac.at/download.html#RExcel -- "You will have to install . a suitable version of R (I have installed R 3.0.1, CRAN Amsterdam) . a matching version of rscproxy . statconnDCOM or rcom with statconnDCOM Download RExcel 3.2.13

Dear List, R packages may specify a "LinkingTo" attribute to specify dependencies to the source code (mainly the header files) of other packages. Unfortunately, it is not possible to also have a reference to the generated library (.dll on Windows) of the other package. So including a header file from another package to call an (exported) function will just not help. I've tried

Hi, I was trying to run your code in my VBA editor, however could not succeed. The execution stumbled in the line "Call Rinterface.StartRServer" itself. I have RCOM package installed into my R environment. Do I need to install anything else to run that? Would guys here guide me? Thanks -- View this message in context: http://n4.nabble.com/R-Excel-Macro-Problem-tp858831p1592196.html

I?ve been using this routine for several years. I?m sorry, I don?t remember where I got it. It works as it should, viz. it blanks the R console. But it requires package rcom and now that requires rscproxy. cls <- function () { require(rcom) wsh <- comCreateObject("Wscript.Shell") comInvoke(wsh, "SendKeys", "\f") invisible(wsh) } > cls()

I have the following error message when I try to install RBloomberg. Les packages binaires t?l?charg?s sont dans C:\Users\bloom\AppData\Local\Temp\RtmpktX4UK\downloaded_packages Message d'avis : packages ?quantstrat?, ?RBloomberg?, ?rsproxy?, ?VaR? are not available (for R version 2.15.1) R version 2.15.1 System : Windows 7 (64 bits) Any help appreciated Thx -- View this message

Thank you Michael, Sarah and Robin for the answers to my original question. Michael you asked:"But this is rarely a good idea....perhaps you could say a little more about your overall goal and we could direct you to a more "R"-ish solution? " I realise eval (known as execute in one of my other languages) is not a good idea. The background to my question is as follows: Using

Dear all, I have been looking for possibilities to read and write Excel 2007-files in and from R. The 'reading' part is ok through odbcConnectExcel2007 and sqlFetch(RODBC). For 'writing' I thought of using sqlSave in the same package, but it does not work (I think because this function starts from an existing file). Is there a workaround for this, or are there other plausible

Hi, I have a problem using RExcel with a foreground server: in RExcel menu as well as in the window called by "set server" the foreground server option is grayed out. I have installed the rcom package and also tried to open R and type require(rcom), as explained on http://sunsite.univie.ac.at/rcom/excel/index.html, but it does not help. What am I missing? Many thanks, Werner

ryusuke: It sounds like you need to have (D)COM server to be able to work on the background. As for the foreground, rcom is what you need and it appears to be working OK. I am out of my office right now but I'll back to work next week and I will be able to explain in more detail how the applications I tied together work with RExcel and R. You can download the latest staconnDCOM.latest.exe from

Hi All Apologies if this is not the correct mailing list for this question. I have installed RExcel and RCom from CRAN. R is indicating that I need an additional file/package "statconnDCOM" from rcom.univie.ac.at I have been trying to access this website over the last 2 days be it appears to be down. Does anyone know when this site is likely to be back up and/or know of an

After installing the package 'rscproxy' downloaded from the CRAN server, I get the following error message from R 2.8.0 about a version conflict : package 'rscproxy' successfully unpacked and MD5 sums checked The downloaded packages are in C:\Documents and Settings\John Meerman\Local Settings\Temp\RtmpbK9mxN\downloaded_packages updating HTML package

Dear All, I am a bit confused, I attached my data frame using 'attach(DATA)' Then I removed it using 'rm(DATA)' But for some reason it is still at position 2 at the search path search() [1] ".GlobalEnv" "DATA" "package:foreign" [4] "package:stats" "package:graphics" "package:grDevices" [7]

Dear Sir Subject: - *Install " rscproxy_1.3-1.tar.gz "* I am working in Windows system. I was try to install *rscproxy* package in two way. *1.* install.packages ("rscproxy_1.3-1.tar.gz"), It shows the Warning: unable to access index for repository http://cran.pt.r-project.org/bin/windows/contrib/2.9 *2. * install.packages("C:/Program

Hello!!! I have been read a much about as read data from Excel File, but I haven?t found the necesary information to read the data. Now, I can create a channel : channel <- odbcConnectExcel("file.xls") but I don?t know as read the data?? I hope that you could help me. Thank you very much. -- View this message in context:

Hi I just would like to know, When I have a dataframe, like this one called 'dummy' And I attach it. Then I run my code. I then update the dataframe by making changes and I still call it 'dummy'. I run my code again. Now dummy is at position 1 and position 2 of the search path and if I run the code again, with another version of 'dummy' it updates and eventually my search