1Excel::Template::ElemenUts:e:rCeCloln(t3r)ibuted Perl DoEcxucmeeln:t:aTteimopnlate::Element::Cell(3)
2
3
4

NAME

6       Excel::Template::Element::Cell - Excel::Template::Element::Cell
7

PURPOSE

9       To actually write stuff to the worksheet
10

NODE NAME

12       CELL
13

INHERITANCE

15       ELEMENT
16

ATTRIBUTES

18       •   TEXT
19
20           This is the text to write to the cell. This can either be text or a
21           parameter with a dollar-sign in front of the parameter name.
22
23       •   COL
24
25           Optionally, you can specify which column you want this cell to be
26           in. It can be either a number (zero-based) or an offset. See
27           Excel::Template for more info on offset-based numbering.
28
29       •   REF
30
31           Adds the current cell to the a list of cells that can be
32           backreferenced.  This is useful when the current cell needs to be
33           referenced by a formula. See BACKREF and RANGE.
34
35       •   WIDTH
36
37           Sets the width of the column the cell is in. The last setting for a
38           given column will win out.
39
40       •   TYPE
41
42           This allows you to specify what write_*() method will be used. The
43           default is to call write() and let Spreadsheet::WriteExcel make the
44           right call. However, you may wish to override it. Excel::Template
45           will not do any form of validation on what you provide. You are
46           assumed to know what you're doing.
47
48           The legal types (taken from Spreadsheet::WriteExcel) are:
49
50       •   COMMENT
51
52           Add a comment to the cell
53
54           •   blank
55
56           •   formula
57
58           •   number
59
60           •   string
61
62           •   url
63
64           •   date_time
65
66           other write_* methods as defined defined Spreadsheet::WriteExcel
67           would be integrated by request
68

CHILDREN

70       FORMULA
71

EFFECTS

73       This will consume one column in the current row.
74

DEPENDENCIES

76       None
77

USAGE

79         <cell text="Some Text Here"/>
80         <cell>Some other text here</cell>
81
82         <cell text="$Param2"/>
83         <cell>Some <var name="Param"> text here</cell>
84
85       In the above example, four cells are written out. The first two have
86       text hard-coded. The second two have variables. The third and fourth
87       items have another thing that should be noted. If you have text where
88       you want a variable in the middle, you have to use the latter form.
89       Variables within parameters are the entire parameter's value.
90
91       Please see Spreadsheet::WriteExcel for what constitutes a legal
92       formula.
93

AUTHOR

95       Rob Kinyon (rob.kinyon@gmail.com)
96

SEE ALSO

98       ROW, VAR, FORMULA
99
100
101
102perl v5.36.0                      2022-07-22 Excel::Template::Element::Cell(3)
Impressum