[R] Is it possible to create highly customized report in *.xls format by using R/S+?

[Greg Snow]

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 copy data from excel (highlight a region in excel and
choose
copy then:)

mydata <- read.delim(file('clipboard'))

to send a dataframe or matrix to excel:

write.table(mydata, file('clipboard'), sep="\t")
(now switch to excel, select a cell and choose paste).

You can also look at the RODBC package for other ways to transfer
information back and forth between R and excel.

For more complicated output you may want to look at the R2HTML package
or the LaTeX functions in Hmisc and other packages (then use a latex
to
rtf converter so you end users can read the output in word or copy it
over
to latex).

Another place to look
is:http://cran.us.r-project.org/contrib/extra/dcom/RSrv135.html

This has examples of building functions in excel that will take the
data from
excel, analyze it in R, then bring the results back to excel.

More detail on what you are trying to do would help us help you.

Greg Snow, Ph.D.
Statistical Data Center, LDS Hospital
Intermountain Health Care
greg.snow at ihc.com
(801) 408-8111

>>> Wensui Liu <liuwensui at gmail.com> 07/20/05 08:55AM >>>
I appreciate your reply and understand your point completely. But at
times we can't change the rule, the only choice is to follow the rule.
Most deliverables in my work are in excel format.

On 7/20/05, Greg Snow <greg.snow at ihc.com> wrote:
> 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
> greg.snow at ihc.com 
> (801) 408-8111
> 
> >>> Wensui Liu <liuwensui at gmail.com> 07/19/05 03:22PM >>>
> 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 at stat.math.ethz.ch mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help 
> PLEASE do read the posting guide!
> http://www.R-project.org/posting-guide.html 
> 
> 


-- 
WenSui Liu, MS MA
Senior Decision Support Analyst
Division of Health Policy and Clinical Effectiveness
Cincinnati Children Hospital Medical Center