in reply to How to set an Excel column to 'AutoFit'

You don't say what you have used to create the Excel file, so I'll assume that it's Spreadsheet::WriteExcel. The documentation for that module's set_column method says this:

Unfortunately, there is no way to specify "AutoFit" for a column in the Excel file format. This feature is only available at runtime from within Excel.

So it looks like you're out of luck.

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

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

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

Replies are listed 'Best First'.
Re^2: How to set an Excel column to 'AutoFit'
by JimRobinson (Initiate) on Jul 21, 2006 at 15:01 UTC
    Thanks guys...I was affraid of that but it doesn't make sense. If I can alter data for the cell at runtime, seems like I could alter the cell width as well. Thanks for the quick response nevertheless.
[reply]

      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

[reply]

In Section Seekers of Perl Wisdom