1Excel::Template::ContaiUnseerr::CWoonrtkrsihbeuette(d3E)Pxecrell:D:oTceummpelnattaet:i:oCnontainer::Worksheet(3)
2
3
4

NAME

6       Excel::Template::Container::Worksheet -
7       Excel::Template::Container::Worksheet
8

PURPOSE

10       To provide a new worksheet.
11

NODE NAME

13       WORKSHEET
14

INHERITANCE

16       Excel::Template::Container
17

ATTRIBUTES

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

CHILDREN

96       None
97

EFFECTS

99       None
100

DEPENDENCIES

102       None
103

USAGE

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

AUTHOR

113       Rob Kinyon (rob.kinyon@gmail.com)
114

SEE ALSO

116       ROW, CELL, FORMULA
117
118
119
120perl v5.32.1                      2021-E0x1c-e2l7::Template::Container::Worksheet(3)
Impressum