Hi Werner, One possibility is to use the xlsReadWritePro package which allows to do this quite easily.
Regards, Moshe. --- Werner Wernersen <[EMAIL PROTECTED]> 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@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. > ______________________________________________ R-help@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.