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_conno...@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]] ______________________________________________ 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.
