good chemistry is complicated, and a little bit messy -LW |
|
PerlMonks |
Re: Is it possible to use back refrences across worksheets with Excel::Template?by jmcnamara (Monsignor) |
on Oct 12, 2011 at 12:53 UTC ( [id://930999]=note: print w/replies, xml ) | Need Help?? |
Looking through the code and the test cases for Excel::Template it looks like backref can only access references in the same worksheet scope. As an alternative you could look at Spreadsheet::WriteExcel::FromXML or Spreadsheet::WriteExcel itself which doesn't have this limitation.
--
In Section
Seekers of Perl Wisdom
|
|