[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