similar to: RExcel + RCOM + Linux

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

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:

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

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

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

A common process when data is obtained in an Excel spreadsheet is to save the spreadsheet as a .csv file then read it into R. Experienced users might have learned to be wary of dates (as I have) but possibly have not experienced what just happened to me. I thought I might just share it with r-help as a cautionary tale. I received an Excel file giving patient details. Each patient had an ID

Hi,   I would like to make a program that reads excel files, and writes the cells of which contents is not a formula to another file. I don't think this is possible with RODBC, but it may be possible with rcom.     I read the documentation of the rcom package, but I was hoping somebody knows a good web resource for more eleborate info. I tried Googling, but alas (did you know rcom also is a

Is this warning given on purpose? > myconn<-textConnection("print(11*11)") > source(myconn) [1] 121 Warning message: In source(myconn) : argument 'encoding = "native.enc"' will be ignored Could it be omitted, since the docs state that encoding is only use if the corresponding argument is a file name or url? -- Erich Neuwirth, University of Vienna

I am looking for information on experimentation with the use of R in the teaching of statistics and science in schools. Any leads would be very welcome. I am certain that there is such experimentation. I've made this inquiry on r-sig-teaching, with no response. John. John Maindonald email: john.maindonald at anu.edu.au phone : +61 2 (6125)3473 fax : +61 2(6125)5549 Centre

Hi R-users! I'm trying to create an easy Excel chart using the package RDCOMClient. The following example is working fine: #------------------------------------------------------------------- library(RDCOMClient) xlLocationAsObject <-2 xlXYScatterSmoothNoMarkers <- 73 ex <- COMCreate("Excel.Application") wb <- ex[["Workbooks"]]$Add() sh <-

I have a big contingency table, approximately of size 60*2*500*500, and I need to count the number of cells containing a count of 1 for each of the factors values defining the first dimension. Here is my attempt: tab1<-with(pisa1,table(CNT,GENDER,ISCOF,ISCOM)) tab2<-apply(tab1,1:4,function(x)ifelse(sum(x)==1,1,0)) tab3<-apply(tab2,1,sum) Computing tab2 is very slow. Is there a faster

I have problems with Rpad and R 2.10.0 (Windows XP and Windows 7, browser is Firefox) Just starting Rpad by library(Rpad) Rpad() opens the browser and displays the .html files and the .Rpad files in my home directory, but these files do not have links and are not clickable. Doing the same in R 2.9.2 gives clickable links in the browser. Furthermore, in both cases an empty graphics window

Hello, I am very new to R and data analysis in general. I am trying to generate values to append to my data frame using conditional statements. I am playing with this simple example: a <- c(1:4) b <- c("meep", "foo", "meep", "foo") d <- cbind(a, b) now what I want to do is , each time there is a "meep" in column 2 of d, print

My configuration is Windows XP, R-2.5.1patched. My standard browser in Windows is Firefox 2.0.6, and I am using htmlhelp. I have problems with starting the browser for displaying help. help("lm") works as it should when Firefox is already running. When I do help("lm") and the browser is not yet started, I get Error in shell.exec(url) :

Is there code for bivariate kernel density estimation? For bivariate kernels there is kde2d in MASS kde2d.g in GRASS KernSur in GenKern (list probably incomplete) but none of them seems to accept a weight parameter (like density does since R 2.2.0) -- Erich Neuwirth, University of Vienna Faculty of Computer Science Computer Supported Didactics Working Group Visit our SunSITE at

I have used xlsReadWrite to read data from an Excel spreadsheet. I had a problem with converting times of the day so that I could create POSIXct date-time objects. I was wondering if there was a better solution. Excel stores times of the day as fractions of a day so I wrote a function to convert the fraction to a number of seconds, extract the hours, minutes and seconds and output it in ISO

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

I just uninstalled R 2.7.2 on Windows XP after having installed R 2.8.0 The uninstaller removed the String values HKEY_LOCAL_MACHINE\SOFTWARE\R-core\R\Current Version HKEY_LOCAL_MACHINE\SOFTWARE\R-core\R\InstallPath despite the fact that they pointed to R 2.8.0 The uninstaller did not remove the key HKEY_LOCAL_MACHINE\SOFTWARE\R-core\R\2.7.2 (and all the values in that key) I think the

I'd like to be able to read multiple sheets from an excel workbook and use the sheet name to name the resulting dataframe using RODBC. at the moment i've figured out how to do it the long way (see below) but feel sure that there is a speedier & possibly automatic way to do it in R. i've tried to run a loop using sqlTables but it seemed to break the connection. unless i've

I do not know if this has been reported already (I searched the headers of the recent messages to r-devel) It seems that 'example' in R 2.11.0 has a problem when the help file does not contain any example. This is what happens on R 2.11.0 on Windows XP. > library(tools) > example(Rdiff) Error in file(con, "r") : cannot open the connection In addition: Warning message: In