NAME

Excel::Template::Container::Worksheet - Excel::Template::Container::Worksheet

PURPOSE

To provide a new worksheet.

NODE NAME

WORKSHEET

INHERITANCE

Excel::Template::Container

ATTRIBUTES

• NAME

  This is the name of the worksheet to be added.

• PROTECT

  If the attribute exists, it will mark the worksheet as being protected. Whatever value is set will be used as the password.

  This activates the HIDDEN and LOCKED nodes.

• KEEP_LEADING_ZEROS

  This will change the behavior of the worksheet to preserve leading zeros.

• LANDSCAPE

  This will set the worksheet's orientation to landscape.

• PORTRAIT

  This will set the worksheet's orientation to portrait.

  While this is the default, it's useful to override the default at times. For example, in the following situation:

  <workbook landscape="1">
    <worksheet>
      ...
    </worksheet
    <worksheet portrait="1">
      ...
    </worksheet
    <worksheet>
      ...
    </worksheet
  </workbook>

  In that example, the first and third worksheets will be landscape (inheriting it from the workbook node), but the second worksheet will be portrait.

CHILDREN

None

EFFECTS

None

DEPENDENCIES

None

USAGE

<worksheet name="My Taxes">
  ... Children here
</worksheet>

In the above example, the children will be executed in the context of the "My Taxes" worksheet.

AUTHOR

Rob Kinyon (rob.kinyon@gmail.com)

SEE ALSO

ROW, CELL, FORMULA