similar to: R (D)COM server 1.2 and RExcel 1.0 available

Just saw this in the Windows Secret blog: Get official and unofficial fixes for Excel By Brian Livingston Despite the hotfix that Microsoft recently released for Excel 2007, as I described on Oct. 11, some math errors that you should know about still lurk in both Excel 2007 and Excel 2003. I'll bring you up to date and explain how you can get better results from Excel. Baier and

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

 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:

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

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

Hi, I'm using R-2.8.1 for windows. I wrote a script calls the RODBC package to run sql queries against an oracle database. It runs fine when run from the rconsole and returns a data.frame with a summary for a set of experiments. I want to run this script using the rinterface.RunRFile command in an excel plugin, using the rexcel package. When I run the code from my excel plugin I

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

Using Thomas Baier's DCOM server I can do the following (in Windows 2000): I create a slider in Excel, and the sliders On_Change event triggers a call to R. This call redraws an R graph, and so I have animated R graphics controlled by Excel's slider. The problem is that Excel needs focus so i can grab the slider, and therefore it partially covers R's graph window. Is there a way to

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

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

Hello: First, RExcel completely rocks! Hat tip to the development team. However, I don't understand something very basic about it. Suppose I put the following code in two cells and choose the Run Code option plot(runif(20),runif(20)) text(.5,.5,"Hello") I get the expected plot. HOWEVER, if I put the following in a cell and hit Run Code, I get nothing. runif(20) HOWEVER, If I

1. This query belongs in r-help, not in r-devel 2. Pity about your shift key... 3. The function you need is deparse() rather than as.character(): > fff <- function(x) { + x*x + } > deparse(body(fff)) [1] "{" "x * x" "}" > 4. There is a reason why as.character works this way. It transforms to character from a more fundamental representation of

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

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

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

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

Dear R users, I've just posted a similar question about Illustrator. This time I would like to export the results of my statistic tables and my dataframes into Excel files. Up to now I've used write.csv(), but I have to resave every file in .xls in Excel. I would like to know if there is a function or package to export directly into *.xls. I have found xlsReadWrite which would be