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

From: bogdan romocea <br44114_at_gmail.com>
Date: Thu 21 Jul 2005 - 23:15:53 EST


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@gmail.com]
> 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 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
>



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 23:27:26 2005

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