Skip site navigation (1)Skip section navigation (2)

FreeBSD Manual Pages

  
 
  

home | help
Excel::Template::ElemeUserCContributed Perl DExcel::Template::Element::Cell(3)

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.32.1			  2012-04-29 Excel::Template::Element::Cell(3)

NAME | PURPOSE | NODE NAME | INHERITANCE | ATTRIBUTES | CHILDREN | EFFECTS | DEPENDENCIES | USAGE | AUTHOR | SEE ALSO

Want to link to this manual page? Use this URL:
<https://www.freebsd.org/cgi/man.cgi?query=Excel::Template::Element::Cell&sektion=3&manpath=FreeBSD+13.0-RELEASE+and+Ports>

home | help