++ed by:
AZJADFTRE

1 PAUSE user
1 non-PAUSE user.

Rob Kinyon

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