similar to: RExcel rcom Server Loading The Wrong Version of R

Dear all, does anyone know if it is possible to connect a Windows RExcel instance to a linux R instance? Within Rexcel, I find the option "Remote Server Address", but I wonder what the installation procedure on my linux (ubuntu) R looks like (if possible at all)? Thanks Philipp

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

Hi, I am trying to use an R function over a column of data I have in my excel spreadsheet. I do the following:- 1) assign an object (calling it xaxis) to the data by typing in =Rput("xaxis",a1:a10), where my data is shown in cells a1:a10 Now I wish to arrive at the mean of these numbers and am doing the following in another cell:- =Rapply("mean","xaxis") This

Hi all :) Before posting, I used the "search" function to find a solution, but I wasn't lucky. I'm using RExcel; I've read several examples which explain how to call in RExcel an R function via =RApply(...) but I don't understand how may I include in the function several numeric arguments. Take this example: I want to use the following R function from

I am using the worksheet functions of RExcel. I am trying to pass a datatable to a function in the following call: =RApply(O14:O18,D6) Cells O14:O18 contain the definition of the function. This is a function that takes one argument which is a data.table. Cell D6 has the name of the data.table object. When I call the function this way, D6 is passed to the function as a string, not as a

Hi community. I'm fairly new to R and have a basic question. When I try to install RExcel with the code: install.packages("RExcelInstaller", "rcom", "rsproxy") I get the message below: Warning in install.packages("RExcelInstaller", "rcom", "rsproxy") : 'lib = "rcom"' is not writable Error in

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

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

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

Hi, I am using RExcel both at work and at home and am facing a couple of challenges. The one at home is that when using RExcel and trying to run any code that involves changing the working directory, I get the following error. Error in command: setwd("C:\\Raoul\\R\\R Maps_UK Maps_Test\\NUTS_03M_2006_SH\\shape\\data")\n cannot change working directory The one at office is more

Hello I am new to RExcel and I would like to run a source code form the excel worksheet. I would like to run the following code source("C:\\Quantil Aplicativos\\Genercauca\\BackwardSelectionNC.r") from the excel wroksheet. Does anybody know how to do this? Thank you Felipe Parra [[alternative HTML version deleted]]

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

> On Mar 1, 2018, at 2:02 PM, Michael Ashton <m.ashton at enduringinvestments.com> wrote: > > Hi - > > For a while I've used RExcel without problems to run a repeating portfolio optimization problem where I solve for a portfolio allocation targeting a particular risk, then solve for a different risk, etc. I call the commands with (e.g.) rinterface.Rrun "(R

Hi list, I used to work with RExcel in excel 2003. Now in 2007, I tried the same RExcel, but it did not work. I got R version 12. I downloaded/installed the latest version of RExcel 3.2.0 from http://sunsite.univie.ac.at/rcom/. It has added the RExcel add-ins, but when I click on starting R in add-ins, I get the following sequentional errors: Errors: SCtools not available SCTools can not be

Hello- I am a Graduate Assistant for an instructor who has written programs for statistics calculations such as binomial distributions and regressions. The programs had worked with no problem in Excel 2003. Now we are trying to use it with Excel 2007, and we are having some trouble. I have downloaded RandFriends and have ran the binomial distribution process in 2007 Excel and have received an

I am having trouble using R routines from the RExcel add-in, that use lapack.dll. As an example if I start the R kernel from within Excel and execute "x<-rbind(c(1,2),c(1,-1)) z<-solve(x)", I get the following error: "Error in solve.default(x): lapack routines could not be loaded. In addition: Warning message: unable to load shared library "C:\Program

Dear all, I have a question regarding background and foreground server in RExcel: Can somebody explain the main difference between them? As far as I understood from the RExcel webpage, for both of them one needs rights for access to Windows registries. The only difference that I can see so far is that for the installation of the background server, one needs the R(D)COM package, whereas for the

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 - For a while I've used RExcel without problems to run a repeating portfolio optimization problem where I solve for a portfolio allocation targeting a particular risk, then solve for a different risk, etc. I call the commands with (e.g.) rinterface.Rrun "(R command)" Recently that macro started blowing up, returning #RErrors, and when I try to trace the error I find that it is

 I have a problem with RExcel which I have now installed on top of R 2.11.0. The problem had been posted in 2009 on the forum by someone else, but no (useful) response had been uploaded. The issue is that whenever I am trying to start R from excel, or by clicking the[ RExcel2007 with RCommander] icon....., I get the following messages boxes : "SCTools not available " then: