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<http://www.lexjansen.com/wuss/2005/data_presentation/dp_using_sas_with_xml.pdf>

As Marc indicated, the "autofit column widths" is a bit confusing.  It would
be better called "set the column width to a number large enough to show all
current contents".

Kevin


On Thu, Jun 4, 2009 at 12:37 AM, Patrick Connolly <
p_connolly@slingshot.co.nz> wrote:

> 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
>
> ~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.
>
> ______________________________________________
> 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.
>

	[[alternative HTML version deleted]]


