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
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
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
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
4 matches
Mail list logo