Re^3: How to control (in a generic way) population of Excel file from another Excel file

in reply to Re^2: How to control (in a generic way) population of Excel file from another Excel file
in thread How to control (in a generic way) population of Excel file from another Excel file

If you're thinking about something like that, why not dump your data into a SQL database and access it that way? Perl has excellent SQL integration and SQL lets you slice and dice data any way you want. If you search on Perl SQL you will find all kinds of tutorials and guides.

Comment on Re^3: How to control (in a generic way) population of Excel file from another Excel file

Replies are listed 'Best First'.
Re^4: How to control (in a generic way) population of Excel file from another Excel file by woland99 (Beadle) on Nov 12, 2015 at 00:25 UTC
Thank you - need to investigate that approach. It would allow for versioning of the incoming data - the input Excel file is coming from a larger database to which we do not have access but periodically we are sent some extract as a feature request.	[reply]

In Section Seekers of Perl Wisdom