[R] Excel Export in a beauty way
Tom Short
tshort.rlists at gmail.com
Mon Jun 8 03:37:54 CEST 2009
Another useful way to create a formatted Excel file is to write out an
HTML file, but put an XLS extension on it. When Excel reads it, it
will convert it. Users will treat it like an Excel file. This trick
allows you to add formatted titles, table footnotes, links to other
files (pdf graphs for example), and more.
To create HTML, you have several packages that can help you out:
R2HTML, Rpad, hwriter, and xtable. Not everything might convert
properly, so you may have to experiment. Data frames as tables
normally convert nicely.
- Tom
Tom Short
More information about the R-help
mailing list