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

[David Winsemius]

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.