[R] Is it possible to create highly customized report in *.xls format by using R/S+?
br44114 at gmail.com
Thu Jul 21 15:15:53 CEST 2005
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
> PLEASE do read the posting guide!
More information about the R-help