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

From: Greg Snow <greg.snow_at_ihc.com>
Date: Thu 21 Jul 2005 - 03:15:40 EST

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@ihc.com
(801) 408-8111

>>> Wensui Liu <liuwensui@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@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@ihc.com
> (801) 408-8111
>
> >>> Wensui Liu <liuwensui@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@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

______________________________________________
R-help@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
Received on Thu Jul 21 03:23:52 2005

This archive was generated by hypermail 2.1.8 : Fri 03 Mar 2006 - 03:33:53 EST