Re: [R] Using R function in Excel

2007-12-08 Thread kchine
Dear John, The R Workbench (biocep project) comes with a powerful Spreadsheet view fully connected to an R session. you can use it to do exactly what you want and it has much more features : from within the spreadsheet view you can : *import any R Data (numeric, integer, character, logic

Re: [R] Using R function in Excel

2007-12-07 Thread Joe W. Byers
John Sorkin wrote: > 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 fun

Re: [R] Using R function in Excel

2007-12-07 Thread Richard M. Heiberger
You are looking for RExcel, which does exactly that. Full documentation and examples are included in the package. http://sunsite.univie.ac.at/rcom/download/devel/ If you don't have R-2.6.1 yet, get the whole R system with the RExcel installed RAndFriendsSetup2061V1.82.exe Otherwise, just get

Re: [R] Using R function in Excel

2007-12-07 Thread Uwe Ligges
See the R(D)COM Server (package "rcom") and RExcel from http://sunsite.univie.ac.at/rcom/ Uwe Ligges John Sorkin wrote: > 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 E