David Winsemius
On Dec 22, 2008, at 11:58 PM, Stavros Macrakis wrote:
> What is the equivalent for formatted tabular output of the various
> very
> sophisticated plotting tools in R (plot, lattice, ggplot2)?
>
> In particular, I'd like to be able to produce formatted Excel
> spreadsheets
> (using color, fonts, borders, etc. -- probably via Excel XML) and
> formatted
> HTML tables (ideally through a format-independent interface), and
> preview
> them using commands within R, just as I would do with R graphics. The
> reason I'd like to produce Excel or HTML rather than (say) TeX or
> PDF is to
> make it easy for the readers of my results to manipulate them in
> their own
> environments (usually Excel). There are various papers on the R-
> project.org
> website related to this topic, but I haven't been able to find any
> particular package supporting this functionality. I have found
> information
> on importing from Excel, calling R functions from Excel, calling COM
> interfaces from R, writing unformatted (CSV) data to Excel, etc.,
> but not on
> producing nicely-formatted tabular output.
>
> I wouldn't have too much trouble putting together something quick-
> and-dirty
> to produce HTML tables, but if someone's already done it well, I'd
> rather
> take advantage of their work. I also don't know enough about COM to
> do
> something as simple as to cause my HTML to display in a browser
> window or my
> XMLSS in Excel....
>
> Thanks,
>
> -s
>
> [[alternative HTML version deleted]]
>
> ______________________________________________
> R-help at r-project.org mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.