similar to: Nice reference to R

We have uploaded a major upgrade of our packages R (D)COM Server V1.2 and RExcel 1.0 The combined package is available in the Software->Other section of CRAN From the documentation: This package contains a COM server used to connect a client application (e.g. Microsoft Excel) with R. An Add-In for Microsoft Excel is provided as well as Active X controls to be included in your

We have uploaded a major upgrade of our packages R (D)COM Server V1.2 and RExcel 1.0 The combined package is available in the Software->Other section of CRAN From the documentation: This package contains a COM server used to connect a client application (e.g. Microsoft Excel) with R. An Add-In for Microsoft Excel is provided as well as Active X controls to be included in your

Dear all, I am quite new to R and for preofessional reasons I was interested in the R/excel interface by Baier and Neuwirth. After setup I see the Rexcel and the Rhelp on the Menu bar of Microsoft Excel XP. However, after putting the formula =RApply("pchisqr", 30, 1) Excel returns the message "could not start Rserver". Any suggestions how to fix this. How do run this

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 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

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

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

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

This is not the right list for your question. Question on how to use R and R's libraries should be posted to R-help at stat.math.ethz.ch Patrick Zhang wrote: > Hello all, > > Trying to implement GARCH(1,1) with ASP.NET <http://asp.net/> and > VB.NET<http://vb.net/>. > It involves optimization of a three-variate function with some constraints. > Learned from

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

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'm pretty new to R and VERY new to RExcel. I've just finished setting it up and I'm having some problems. My first Issue is that if I attempt to use a function like RApply("sum", A1:A4) from within excel it gives me an error saying "There seems to be no R process connected to the server" I can then see an R Console open up and I get a message saying R

Today we uploaded a new release of the R (D)COM server for Windows to CRAN. It is release 1.35 The software is much more stable, and there are quite a few improvements. Excerpts from the NEWS file: RServerManager has been added. This provides a repository for R COM servers. See the samples and the additional documentation Partial rewrite of the code for SetSymbol() and GetSymbol(). Now

Today we uploaded a new release of the R (D)COM server for Windows to CRAN. It is release 1.35 The software is much more stable, and there are quite a few improvements. Excerpts from the NEWS file: RServerManager has been added. This provides a repository for R COM servers. See the samples and the additional documentation Partial rewrite of the code for SetSymbol() and GetSymbol(). Now

> 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

> From: Thomas Baier > > > I am confused as to what I need and must do. > > > > Your message said > > ftp://cran.r-project.org/pub/R/src/contrib/Devel/rcom_0.97.tar.gz > > > > The DESCRIPTION file inside that download says > > Package: rcom > > Version: 0.95 > > Date: 2004-07-14 > > That's too bad. Sorry for that. > >

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

RExcelInstaller_2.0-15 installs RExcel, an add-in for Excel, which connects R and Excel. RExcel allows to transfer data between R and Excel, writing VBA macros using R as a library for Excel, and calling R functions as worksheet function in Excel. RExcel integrates nicely with R Commander (Rcmdr), turning R Commander's menus into Excel menus. It comes with a comprehensive set of example

I am running R as an invisible subprocess in another program (RExcel). Using try I can catch errors and print the errors produced by an R statement. Is there a way to know if running a statement caused a warning message? last.warning gives me the last warning, but I do not have any indication what the statement was that caused the message. I can of course store last warning before I run a