similar to: Excel-to-R Interface

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

Hello, I am new to this list. ?I am trying to compile the current svn version of kdeedu on an amd64 linux machine ?which uses R and I get the following compiler output. ------------------------------------------- ?79%] Building CXX object cantor/src/backends/R/rserver/CMakeFiles/cantor_rserver.dir/rserver.o $SOURCES/kdeedu/cantor/src/backends/R/rserver/rserver.cpp: In member function

It's not in R, but the system described in the pair of papers our group published in the Journal of Biomolecular Screening late last year: http://jbx.sagepub.com/cgi/content/refs/8/6/624 http://jbx.sagepub.com/cgi/content/refs/8/6/634 is based on S-PLUS and StatServer. It was also presented at the Insightful Tech. Conf. back in 2000. For Excel/R connection, look for the R-(D)COM server on

summary: e.g., how to replace '<query R for package=package_name>' in the following: for RSERVER in 'foo' 'bar' 'baz' ; do ssh ${RSERVER} '<query R for package=package_name>' done or is there a better way to script checking for an R package? details: For my work I need a few non-standard R packages. I do that work on 2 clusters. One uses

Dear All, I have attempted to install the R-Excel Interface with poor results. The version of R is 1.6.1, the version of R-Excel is 1.0, the version of COM is 0.99. All of these were downloaded Monday, 6 January 2003. R (version 1.6.1) is installed on the machine and appears to run correctly on its own. The computer is a Compaq Pentium 4 machine with 128 meg of RAM running Windows 2000 and

Estimado Carlos Ortega Recién leo en mi sistema,  checkpoint(), no tengo una fecha configurada. Instalaré la versión CRAN y que coexistan. En estos momentos no necesito una característica de análisis estadístico, pero si estoy viendo y pensado con algunas pruebas, el utilizar R para reportes, en ese caso una opción es SqlServer 2016, otra conectar R a java o c#, no recuerdo justo el nombre

Estimados La última vez que instale R fue en conjunto con sqlserver 2016, por lo cuál sería rserver. Actualice Rstudio y por ejemplo el Rnotebook requiere una actualización (pandoc y etc.) Pero al colocar la actualización de paquetes desde Rstudio informa que están todos actualizados, sin embargo el mismo también detecta que no es así, puesto que lo informa como dependencias necesarias para

Hello, Has anyone tried to call R API from Delphi under windows ? How was it done if it was ? Or has anyone any idea about how it could be done ? Thanks for your answers Laurent Tessier [[alternative HTML version deleted]]

Hi, I am using R and I want to know how data can be transferred from Excel Spread sheet to R for analyzing. I have done like this mydata<-read.table("C:\Documents and Settings\admin\Desktop\data.txt"); but its not working how can i do it regards Sarath Sankar V

The system is FC4 with the latest upgrades installed. Wine is 0.9.5. The latest wine is doing the best at running Office in a long time. Word seems very stable. That said excel is hanging on the splash screen. This in an old symptom that keeps re-occurring. DCOM is installed correctly. Does anyone know what the cause of he splash screen excel is? Thanks - Dan

I have Excel files containing data that I would like to move to R. They are in the standard form of a one row header followed by rows of data, one record per row EXCEPT that there are a few rows of comments before the header. The number of rows of comments varies. For Excel files of this form without comments I have had success with: require(RODBC) z <-

I am trying to read an Excel file using the following: a<-read.xls("mydata.xls", sheet=1) The file mydata.xls is stored in the working directory. However I am getting the following error. Can anyone help. Error in findPerl(verbose = verbose) : perl executable not found. Use perl= argument to specify the correct path. Error in file.exists(tfn) : invalid 'file' argument --

I have a data.frame datas which have two columns A and B. I want to filter column A by some values and to get a value list which contain the value in B. Best wishes! [[alternative HTML version deleted]]

Buenos días a todos! Estoy trabajando con una base de datos que directamente he descargado de internet y después de prepararla un poco necesito exportarla a Excel he intentando con las dos opciones que mencionaré al final pero ninguna funciona, de qué otra manera puedo exportar esos datos a Excel... muchas gracias por su ayuda y pronta respuesta! 1) library(xlsx) library(rJava)

A friend of mine can't send emails to the R-list from his work and he had a question that he asked me to send because I don't know the answer to his question. I did suggest the cran packages list and the search function but I think he wasn't successful ? He needs to do a quick prototype in R with Excel interface and was wondering if it was possible to implemented R calls from Excel, (

Dear All, I am trying to install R 2.7 on my openSUSE 10.3. I have faithfully followed instruction at http://cran.r-project.org/bin/linux/suse/ReadMe.txt. I have downloaded all the RPMs but still R complains about: libtcl8.4.so is needed by R-base-2.7.1-6.1.i586 I searched for this library and found a one, tcl-8.4.15-22.i586.rpm at openSUSE distribution site and installed. But R still complains

Hi all, OPC is a standard that specifies a collection of DCOM interfaces heavely used in the industrial automation domain. (http://www.opcfoundation.org) I would like to access these OPC objects that run in Windows from Linux computers, using the DCOM framework. Instead of implementing DCOM from scratch for Linux, I was considering 'stealing' some code off the SAMBA project relating

Sir, I am a beginner in R language. I want to import data from excel to R. My data contains not only numeric values but also string values.I want to draw a boxplot graph . I can't import or write this string data. it is essential for my graph.Please give me a suggestion for This. Thanking You, BLESSY.C.F. [[alternative HTML version deleted]]

Hi experts, I want to read data from an excel data like this: for the fifth column, from first row until 140 but only 1,3,5,7,.....139 (only 70 values), How can I do it in R? thanks [[alternative HTML version deleted]]

A colleague has a dozen of excel sheets and also expects to get updates regularly. He could open these in M$-Excel and export as *.csv manually, "bring back to Unix" and then read into R. Of course there must be options to start programming this in something like visual basic, but we wouldn't to really want to... We also know that probably Gnumeric could do the job (since the xls