R help - Jul 2005 - Is it possible to create highly customized report in *.xls format by using R/S+?

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!

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

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

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

So your conclusion is that the only choice is to make mistakes and get
in trouble. (That's what Excel excels at.)

Two options I haven't seen mentioned are:
1. Create your deliverables in HTML format, and change the extension
from .htm to .xls; Excel will import them automatically. The way the
file looks in Excel is determined by .CSS settings (I've seen this
happen) and I presume HTML tags.
2. For the real spreadsheet thing, switch to OpenOffice.org. Their
format is XML compressed with ZIP which you can easily work with since
the format specifications are not proprietary. See
http://xml.openoffice.org/ for details.


> -----Original Message-----
> From: Wensui Liu [mailto:liuwensui at gmail.com] 
> Sent: Wednesday, July 20, 2005 10:56 AM
> To: Greg Snow
> Cc: r-help at stat.math.ethz.ch
> Subject: Re: [R] Is it possible to create highly customized 
> report in *.xls format by using R/S+?
> 
> 
> 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
> 
> ______________________________________________
> 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
>