Tim Howell > Excel-Template-Element-Cell-AutoSize-0.04 > Excel::Template::Element::Cell::AutoSize

Download:
Excel-Template-Element-Cell-AutoSize-0.04.tar.gz

Dependencies

Annotate this POD

Related Modules

Excel::Template
PDF::Template
Win32::API
GD::Graph
Mac::PropertyList
PDF::API2
PDF::Report
Geo::IP
more...
By perlmonks.org

CPAN RT

New  4
Open  0
View/Report Bugs
Module Version: 0.04   Source  

NAME ^

Excel::Template::Element::Cell::AutoSize

PURPOSE ^

To provide a cell that is correctly sized for inserted text

NODE NAME ^

CELLAUTOSIZE

INHERITANCE ^

Excel::Template::Element::Cell

CHILDREN ^

Excel::Template::Element::Formula

EFFECTS ^

This will consume one column on the current row.

DEPENDENCIES ^

Font::TTFMetrics

USAGE ^

  <cellautosize text="Some Text Here"/>
  <cellautosize>Some other text here</cellautosize>

  <cellautosize text="$Param2"/>
  <cellautosize>Some <var name="Param"> text here</cellautosize>

In the above example, four cells are written out. The first two have text hard- coded. The second two have variables. The third and fourth items have another thing that should be noted. If you have text where you want a variable in the middle, you have to use the latter form. Variables within parameters are the entire parameter's value.

Please see Spreadsheet::WriteExcel for what constitutes a legal formula.

AUTHOR ^

Tim Howell (tim@fefcful.org) Based on Excel::Template::Element::Cell by Rob Kinyon

SEE ALSO ^

CELL, ROW, VAR, FORMULA

syntax highlighting: