GSP
Quick Navigator

Search Site

Unix VPS
A - Starter
B - Basic
C - Preferred
D - Commercial
MPS - Dedicated
Previous VPSs
* Sign Up! *

Support
Contact Us
Online Help
Handbooks
Domain Status
Man Pages

FAQ
Virtual Servers
Pricing
Billing
Technical

Network
Facilities
Connectivity
Topology Map

Miscellaneous
Server Agreement
Year 2038
Credits
 

USA Flag

 

 

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

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

To actually write stuff to the worksheet

CELL

ELEMENT

  • 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.

  • 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.

  • 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.

  • WIDTH

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

  • 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:

  • COMMENT

    Add a comment to the cell

  • blank
  • formula
  • number
  • string
  • url
  • date_time

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

FORMULA

This will consume one column in the current row.

None

  <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.

Rob Kinyon (rob.kinyon@gmail.com)

ROW, VAR, FORMULA
2012-04-29 perl v5.32.1

Search for    or go to Top of page |  Section 3 |  Main Index

Powered by GSP Visit the GSP FreeBSD Man Page Interface.
Output converted with ManDoc.