Re: [R] Excel Export in a beauty way

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 exa

Re: [R] Excel Export in a beauty way

Hi, Here's a function to export dataframes to an excel-file with the RDCOMClient package. It makes bold headers and fits the column widths automatically. If more than one dataframe is provided to the function, the dataframes are saved to seperate spreadheets within file. export.xls <- functi

Re: [R] Excel Export in a beauty way

Also see this post at https://stat.ethz.ch/pipermail/r-help/2008-July/169149.html The same idea is discussed in a SAS proceedings paper (but it is NOT specific to SAS) www.lexjansen.com/wuss/2005/data_presentation/dp_using_*sas*_with_xml.pdf

Re: [R] Excel Export in a beauty way

On Wed, 03-Jun-2009 at 08:54AM -0500, Marc Schwartz wrote: [...] > For example, using the Perl package that I do for the WriteXLS > package, it is not possible to use the "AutoFit" capability to > easily set all column widths wide enough to visually allow for the > data contained within each. Fro

Re: [R] Excel Export in a beauty way

If you are willing to do the work RDCOMClient or rcom packages give you complete control. See example here: https://stat.ethz.ch/pipermail/r-help/2005-July/075877.html This assumes your platform is Windows and that you have R and Excel on the same machine so that R can control Excel. On Wed, Jun

Re: [R] Excel Export in a beauty way

Hi, I would just add, for myself, not for others who have developed R to Excel export packages, that the efficient export of data from R to a native Excel file is the priority. Formatting (columns, fonts, colors, etc.) in the resultant spreadsheets (for me) was not. There are also some fu

Re: [R] Excel Export in a beauty way

If you are working on Windows and Excel installed on the same machine as R, the rcom library by Thomas Baier gives you full programmability for Excel From R. You can control all the effect you want. You also could use the RExcel addin for Excel which allows to transfer date from R into Excel

[R] Excel Export in a beauty way

Hallo all, I`ve read a lot of things in this forum about an Excel export via R. It is no problem to export my data frames via write.table or write.xls (xls or csv), but some things are not very convenient for me: I always have to adjust the column with to see all the numbers or the text and there