Re: Spread***::WriteExcel format width

In article <1116615850.751089.186030@xxxxxxxxxxxxxxxxxxxxxxxxxxxx>,
David Lao <David.C.Lao@xxxxxxxxx> wrote:
>Hi,
>
>I tried to format the width of the columns but the value did not take.
>When I open the perl.xls file, I saw the columns default to 10 for the
>width. Do you know why ?
>
>Here is the snippet of the code:
>
> $work***->set_column($row, $col, 30);

Check the documentation for Spread***::WriteExcel. The set_column method
looks like this:

set_column($first_col, $last_col, $width, $format, $hidden, $level)

It doesn't take a row number. I suspect you want

$work***->set_column($col, $col, 30);

- Gary Ansok
.