similar to: What's the best way to operate R from within Excel?

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

Does anyone know a way that an function written in R can be called within a cell of an Excel spreadsheet. I would like to use the R function much as I use the native Excel functions, e.g. instead of using the excel function sum, =sum(A2,A6), I would like to use the function mysum written in R, e.g. =mysum(A2,A6). Thanks, John John Sorkin M.D., Ph.D. Chief, Biostatistics and Informatics

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:

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

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

Dear R-experts, It is a quite stupid question but please help me. I am very confuced. I am able to import normal txt ant mat-files to R but unable to import .xls-file I do not understand the online help. Can please anyone send me the corresponding command lines? The .xls-file is attached. In my file we use commas for the decimal format (example: 0,712), changes might be needed. Thanks, Corinna

Even using the VBA back of Excel to create interfaces with R would make a lot of sense. Suppose I could have access to VBA macros that import and export data into R , it would be great. The R GUI series like Rattle come even closer to Excel...so a VBA _R_ExCel package might be useful to ordinary folks . Besides Excel costs money, so adding R functions to Open Office would help both of them ( if

Hi all, I tried to read data from Excel spread sheet with using read.csv(file.choose()) and read.delim(file.choose()) but its showing " *ÐÏ.à.*." and also i tried with read.table(file.choose()) then its showing " * V1 1 ÐÏ\021ࡱ* " can any one suggest how to read data from Excel Spread sheet

Hi all, In R GUI window, if you use "up" and "down" key, you will be able to recall the previous and next command that has been used and stored in the command history cache. But there is one inconvenience: In Matlab, you can type the first a few characters of the command that you previously used, and then press ?up" key, you will be able to get to that previous

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

Is there an "easy" or good way to run/launch an Excel VBA macro from within R? --------------------------------- Pinpoint customers who are looking for what you sell. [[alternative HTML version deleted]]

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

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

Hallo all, I`ve read a lot of things in this forum about an Excel export via R. It is no problem to export my data frames via write.table or write.xls (xls or csv), but some things are not very convenient for me: I always have to adjust the column with to see all the numbers or the text and there is no frame between the cells. And I missing the possibility to make some headers bold or coloured.

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

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

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