excel::template::element::backref(3pm) [debian man page]

Excel::Template::Element::Backref(3pm)			User Contributed Perl Documentation		    Excel::Template::Element::Backref(3pm)

NAME

       Excel::Template::Element::Backref - Excel::Template::Element::Backref

PURPOSE

       Returns the cell location (i.e. B2) of the last cell to name this reference.  To return the location of the entire range of cells to name
       this reference see RANGE.

NODE NAME

       BACKREF

INHERITANCE

       Excel::Template::Element

ATTRIBUTES

       o   REF

	   This is the name of the reference to look up.

CHILDREN

       None

EFFECTS

       None

DEPENDENCIES

       This will only be used within CELL tags.

USAGE

       In the example...

	 <row>
	   <cell ref="this_cell"/><cell ref="that_cell"><cell ref="that_cell">
	 </row>
	 <row>
	   <formula>=<backref ref="this_cell">+<backref ref="that_cell"></formula>
	 </row>

       The formula in row 2 would be =A1+C1.  C1 is the last to reference "that_cell".

AUTHOR

       Rob Kinyon (rkinyon@columbus.rr.com)

SEE ALSO

       CELL, RANGE

perl v5.14.2							    2012-04-29				    Excel::Template::Element::Backref(3pm)

Excel::Template::Element::Cell(3pm)			User Contributed Perl Documentation		       Excel::Template::Element::Cell(3pm)

NAME

       Excel::Template::Element::Cell - Excel::Template::Element::Cell

PURPOSE

       To actually write stuff to the worksheet

NODE NAME

       CELL

INHERITANCE

       ELEMENT

ATTRIBUTES

       o   TEXT

	   This is the text to write to the cell. This can either be text or a parameter with a dollar-sign in front of the parameter name.

       o   COL

	   Optionally, you can specify which column you want this cell to be in. It can be either a number (zero-based) or an offset. See
	   Excel::Template for more info on offset-based numbering.

       o   REF

	   Adds the current cell to the a list of cells that can be backreferenced.  This is useful when the current cell needs to be referenced
	   by a formula. See BACKREF and RANGE.

       o   WIDTH

	   Sets the width of the column the cell is in. The last setting for a given column will win out.

       o   TYPE

	   This allows you to specify what write_*() method will be used. The default is to call write() and let Spreadsheet::WriteExcel make the
	   right call. However, you may wish to override it. Excel::Template will not do any form of validation on what you provide. You are
	   assumed to know what you're doing.

	   The legal types (taken from Spreadsheet::WriteExcel) are:

       o   COMMENT

	   Add a comment to the cell

	   o   blank

	   o   formula

	   o   number

	   o   string

	   o   url

	   o   date_time

	   other write_* methods as defined defined Spreadsheet::WriteExcel would be integrated by request

CHILDREN

       FORMULA

EFFECTS

       This will consume one column in the current row.

DEPENDENCIES

       None

USAGE

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

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

       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

       Rob Kinyon (rob.kinyon@gmail.com)

SEE ALSO

       ROW, VAR, FORMULA

perl v5.14.2							    2012-04-29				       Excel::Template::Element::Cell(3pm)