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@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.
______________________________________________
R-help@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.