R help - May 2008 - perform statistics on an Excel workbook and modify it

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.

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