Excel::Template::Element::Cell::AutoSize
To provide a cell that is correctly sized for inserted text
CELLAUTOSIZE
Excel::Template::Element::Cell
Excel::Template::Element::Formula
This will consume one column on the current row.
Font::TTFMetrics
<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.
Tim Howell (tim@fefcful.org) Based on Excel::Template::Element::Cell by Rob Kinyon
CELL, ROW, VAR, FORMULA
To install Excel::Template::Element::Cell::AutoSize, copy and paste the appropriate command in to your terminal.
cpanm
cpanm Excel::Template::Element::Cell::AutoSize
CPAN shell
perl -MCPAN -e shell install Excel::Template::Element::Cell::AutoSize
For more information on module installation, please visit the detailed CPAN module installation guide.