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.

• HIDE_GRIDLINE

  his method is used to hide the gridlines on the screen and printed page. Gridlines are the lines that divide the cells on a worksheet. Screen and printed gridlines are turned on by default in an Excel worksheet. If you have defined your own cell borders you may wish to hide the default gridlines.

  $worksheet->hide_gridlines();

  The following values of $option are valid:

  0 : Don't hide gridlines
  1 : Hide printed gridlines only
  2 : Hide screen and printed gridlines

  If you don't supply an argument or use undef the default option is 1, i.e. only the printed gridlines are hidden.

• 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