in reply to Re^2: How to set an Excel column to 'AutoFit'
in thread How to set an Excel column to 'AutoFit'

Jim,

You may have misread the documentation. The "set_column" method does allow you to alter the cell width. But you have to give it a "real" width; you can't just ask for the "best fit" width (which is what AutoFit does).

I see that John has posted a link to a workaround that allows you to calculate a width that is approximately what AutoFit would give you.

--
<http://dave.org.uk>

"The first rule of Perl club is you do not talk about Perl club."
-- Chip Salzenberg

  • Comment on Re^3: How to set an Excel column to 'AutoFit'