[R] Excel Export in a beauty way

Patrick Connolly p_connolly at slingshot.co.nz
Thu Jun 4 07:37:36 CEST 2009


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. From the available Perl package
> documentation, this appears to be a "run time" only feature, which
> means that it would require Excel to be available and running and
> the user either going through the column formatting menu, or
> creating a macro to automate the process.

I've used that Perl script for some time and find it very useful
(thanks Marc).  I can't see a lot of point in trying to get the column
widths done by it.  In Excel, it's very easy to highlight every column
and then double click on the line separating any two column names and
that will set ALL the widths to their optimum in one go.
(Just in case anyone didn't know.)

If that's not sufficient, one of those other methods might suit.

-- 
~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.   
   ___    Patrick Connolly   
 {~._.~}                   Great minds discuss ideas    
 _( Y )_  	         Average minds discuss events 
(:_~*~_:)                  Small minds discuss people  
 (_)-(_)  	                      ..... Eleanor Roosevelt
	  
~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.




More information about the R-help mailing list