Thank you all for the replies. It is very eye-opening for me.
I probably need something like RDCOMClient. I've tried it last night.
Very nice package!!!
On 7/20/05, Gabor Grothendieck [EMAIL PROTECTED] wrote:
Here is an example where R is the client and Excel is the server
so that R is issuing
://xml.openoffice.org/ for details.
-Original Message-
From: Wensui Liu [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 20, 2005 10:56 AM
To: Greg Snow
Cc: r-help@stat.math.ethz.ch
Subject: Re: [R] Is it possible to create highly customized
report in *.xls format by using R/S+?
I
See:
http://www.burns-stat.com/pages/Tutor/spreadsheet_addiction.html
and
http://www.stat.uiowa.edu/~jcryer/JSMTalk2001.pdf
Greg Snow, Ph.D.
Statistical Data Center, LDS Hospital
Intermountain Health Care
[EMAIL PROTECTED]
(801) 408-8111
Wensui Liu [EMAIL PROTECTED] 07/19/05 03:22PM
I
When you are forced to use excel (but want to really use R and just
give the result to others in excel), then there are a few options
depending on what you are trying to do. We may be able to give
better help if you can give a specific problem you are trying to
solve.
Some Ideas:
To quickly
Here is an example where R is the client and Excel is the server
so that R is issuing commands to Excel. This example uses the
RDCOMClient package from www.omegahat.org:
library(RDCOMClient)
xl - COMCreate(Excel.Application) # starts up Excel
xl[[Visible]] - TRUE
I remember in one slide of Prof. Ripley's presentation overhead, he
said the most popular data analysis software is excel.
So is there any resource or tutorial on this topic?
Thank you so much!
__
R-help@stat.math.ethz.ch mailing list