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.
"The first rule of Perl club is you do not talk about
Perl club."
-- Chip Salzenberg
|
|---|