[R] Tabular output: from R to Excel or HTML

David Winsemius dwinsemius at comcast.net
Tue Dec 23 06:45:00 CET 2008

You should be looking at odfWeave. It has support for the OpenOffice  
table formatting and once those are created, the conversion to Excel  
should proceed smoothly.

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.

More information about the R-help mailing list