Robert Bohne > Excel-Template-0.34 > Excel::Template::Element::Range

Download:
Excel-Template-0.34.tar.gz

Dependencies

Annotate this POD

CPAN RT

New  4
Open  0
View/Report Bugs
Source  

NAME ^

Excel::Template::Element::Range - Excel::Template::Element::Range

PURPOSE ^

Returns a range of cell locations (i.e. B2:C2) that contains all calls using this reference. To return the location of the last cell, use BACKREF.

NODE NAME ^

RANGE

INHERITANCE ^

Excel::Template::Element

ATTRIBUTES ^

CHILDREN ^

None

EFFECTS ^

None

DEPENDENCIES ^

This will only be used within CELL tags.

USAGE ^

In the example...

  <row>
    <cell ref="this_cell"/><cell ref="that_cell"><cell ref="that_cell">
  </row>
  <row>
    <formula>=SUM(<range ref="that_cell">)</formula>
  </row>

The formula in row 2 would be =SUM(B1:C1).

AUTHOR ^

Rob Kinyon (rkinyon@columbus.rr.com)

SEE ALSO ^

CELL, BACKREF

syntax highlighting: