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]]
Hi Stavros,> What is the equivalent for formatted tabular output of the various very > sophisticated plotting tools in R (plot, lattice, ggplot2)?For the tabulation itself the reshape package by Hadley Wickham might be a handy tool: http://had.co.nz/reshape/> 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....For the HTML part of your question, you can have a look at - hwriter - R2HTML Both packages are on CRAN. See also http://www.ebi.ac.uk/~gpau/hwriter/ HTH, Tobias
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.