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


Manual Reference Pages  -  EXCEL::TEMPLATE::ELEMENT::CELL (3)

.ds Aq ’

NAME

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

CONTENTS

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
Search for    or go to Top of page |  Section 3 |  Main Index


perl v5.20.3 EXCEL::TEMPLATE::ELEMENT::CELL (3) 2012-04-29

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