1 package Excel::Template::Container::Worksheet;
7 @ISA = qw(Excel::Template::Container);
9 use Excel::Template::Container;
17 $context->new_worksheet( $self );
19 my $password = $context->get( $self, 'PROTECT' );
20 if (defined $password)
22 $context->active_worksheet->protect( $password );
25 my $keep_zeros = $context->get( $self, 'KEEP_LEADING_ZEROS' );
26 if ( defined $keep_zeros )
28 $context->active_worksheet->keep_leading_zeros( $keep_zeros ? 1 : 0 );
31 return $self->SUPER::render($context);
39 Excel::Template::Container::Worksheet - Excel::Template::Container::Worksheet
43 To provide a new worksheet.
51 Excel::Template::Container
59 This is the name of the worksheet to be added.
63 If the attribute exists, it will mark the worksheet as being protected. Whatever
64 value is set will be used as the password.
66 This activates the HIDDEN and LOCKED nodes.
68 =item * KEEP_LEADING_ZEROS
70 This will change the behavior of the worksheet to preserve leading zeros.
88 <worksheet name="My Taxes">
92 In the above example, the children will be executed in the context of the
97 Rob Kinyon (rob.kinyon@gmail.com)