Excel::Template::Element::Range
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.
RANGE
Excel::Template::Element
REF
This is the name of the reference to look up.
None
This will only be used within CELL tags.
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).
Rob Kinyon (rkinyon@columbus.rr.com)
CELL, BACKREF
To install Excel::Template, copy and paste the appropriate command in to your terminal.
cpanm
cpanm Excel::Template
CPAN shell
perl -MCPAN -e shell install Excel::Template
For more information on module installation, please visit the detailed CPAN module installation guide.