in reply to Re: Problems setting Excel cell width
in thread Problems setting Excel cell width

Thanks for that. I wondered if it was a units issue .
Do you happen to know if there is some way of retrieving and setting a cell or column width that uses the same unit?
  • Comment on Re^2: Problems setting Excel cell width

Replies are listed 'Best First'.
Re^3: Problems setting Excel cell width
by hominid (Priest) on Jan 27, 2010 at 20:25 UTC
    ColumnWidth will do it.

    To set: 

    $sheet  -> Range("F4") -> {ColumnWidth} = 60;

    [download]
    To get: 
    my $columnwidth = $sheet  -> Range("F4") -> {ColumnWidth};

    [download]

[reply]
[d/l]
[select]

In Section Seekers of Perl Wisdom