NAME

Excel::Template::Element::Column - Excel::Template::Element::Column

PURPOSE

To set the width of a column or columns

NODE NAME

COLUMN

INHERITANCE

Excel::Template::Element

ATTRIBUTES

• NAME

  This is the Excel name for the column(s) you want to affect. This is a range, so you will need to say "A:A" in order to affect the first column.

• WIDTH

  This is the width you want to set the column to. To determine a size, you should figure on roughly how long you expect a string in default Arial 10 to be. Since Auto-fit is a feature only available from within Excel at runtime, there is no way to specify it through either this distribution or [Spreadheet::WriteExcel] (the rendering engine).

There will be more parameters added, as features are added. Additionally, this node might (someday) be able to calculate how much space the data you have written to that column actually needs.

CHILDREN

None

EFFECTS

None

DEPENDENCIES

None

USAGE

<column name="A:A" width="20" />
<column name="C:E" width="30" />

In the above example, the width of the first column is set to 20 and the width of the third, fourth, and fifth columns are set to 30.

This node can be used anywhere under a worksheet node.

AUTHOR

Rob Kinyon (rkinyon@columbus.rr.com)

SEE ALSO

Nothing