1Excel::Template::ContaiUnseerr::CWoonrtkrsihbeuette(d3E)Pxecrell:D:oTceummpelnattaet:i:oCnontainer::Worksheet(3)
2
3
4
6 Excel::Template::Container::Worksheet -
7 Excel::Template::Container::Worksheet
8
10 To provide a new worksheet.
11
13 WORKSHEET
14
16 Excel::Template::Container
17
19 • NAME
20
21 This is the name of the worksheet to be added.
22
23 • PROTECT
24
25 If the attribute exists, it will mark the worksheet as being
26 protected. Whatever value is set will be used as the password.
27
28 This activates the HIDDEN and LOCKED nodes.
29
30 • KEEP_LEADING_ZEROS
31
32 This will change the behavior of the worksheet to preserve leading
33 zeros.
34
35 • HIDE_GRIDLINE
36
37 his method is used to hide the gridlines on the screen and printed
38 page. Gridlines are the lines that divide the cells on a
39 worksheet. Screen and printed gridlines are turned on by default in
40 an Excel worksheet. If you have defined your own cell borders you
41 may wish to hide the default gridlines.
42
43 $worksheet->hide_gridlines();
44
45 The following values of $option are valid:
46
47 0 : Don't hide gridlines
48 1 : Hide printed gridlines only
49 2 : Hide screen and printed gridlines
50
51 If you don't supply an argument or use undef the default option is
52 1, i.e. only the printed gridlines are hidden.
53
54 • LANDSCAPE
55
56 This will set the worksheet's orientation to landscape.
57
58 • PORTRAIT
59
60 This will set the worksheet's orientation to portrait.
61
62 While this is the default, it's useful to override the default at
63 times. For example, in the following situation:
64
65 <workbook landscape="1">
66 <worksheet>
67 ...
68 </worksheet
69 <worksheet portrait="1">
70 ...
71 </worksheet
72 <worksheet>
73 ...
74 </worksheet
75 </workbook>
76
77 In that example, the first and third worksheets will be landscape
78 (inheriting it from the workbook node), but the second worksheet
79 will be portrait.
80
81 • AUTOFILTER
82
83 With these attribute, you can add the autofilter to a worksheet. An
84 autofilter is a way of adding drop down lists to the headers of a
85 2D range of worksheet data. This is turn allow users to filter the
86 data based on simple criteria so that some data is shown and some
87 is hidden.
88
89 Example to add an autofilter to a worksheet:
90 <workbook>
91 <worksheet autofilter='A1:D11' />
92 <worksheet autofilter='0, 0, 10, 3' />
93 </workbook>
94
96 None
97
99 None
100
102 None
103
105 <worksheet name="My Taxes">
106 ... Children here
107 </worksheet>
108
109 In the above example, the children will be executed in the context of
110 the "My Taxes" worksheet.
111
113 Rob Kinyon (rob.kinyon@gmail.com)
114
116 ROW, CELL, FORMULA
117
118
119
120perl v5.34.0 2022-E0x1c-e2l1::Template::Container::Worksheet(3)