[R] perform statistics on an Excel workbook and modify it

Moshe Olshansky m_olshansky at yahoo.com
Wed May 28 01:30:36 CEST 2008


Hi Werner,

One possibility is to use the xlsReadWritePro package
which allows to do this quite easily.

Regards,

Moshe.

--- Werner Wernersen <pensterfuzzer at yahoo.de> wrote:

> Hi,
> 
> I have an Excel (2000 / 2003) workbook with multiple
> sheets on which I would like to perform several
> statistical operations. Since I have written most of
> the necessary code in R earlier I would like to do
> this in R. Now, I am wondering what is the best
> method
> to programmatically load different cell ranges from
> the work sheets as data frames into R and then write
> several cell ranges back to the Excel workbook? 
> 
> I suppose that there are different ways to do this
> in
> R but I think it is not that quick to get into each
> of
> those methods and thus would appreciate a
> recommendation on which one is the most promising
> for
> such a task.
> 
> Thanks a million for your help,
>   Werner
> 
> 
>      
>
__________________________________________________________
> 
> Dem pfiffigeren Posteingang.
> 
> ______________________________________________
> R-help at r-project.org mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide
> http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained,
> reproducible code.
>



More information about the R-help mailing list