in reply to Binary Excel Templates
As such it isn't possible to template a binary Excel file in the same way that you would template a text file.
Hence the route that Excel::Template and Spreadsheet::WriteExcel::FromXML take where the tempate file is text or XML based and the backend uses Spreadsheet::WriteExcel to create the Excel binary file.
The newer xlsx Excel files from Excel 2007 onwards are XML files contained in a zip file and are more suitable for TT style templating.
As an aside I am working on an xlsx writer module that will eventually read and rewrite files as well so that it will be possible to use an existing file as a template (although not in the TT sense). However, that work is still at an early stage.
--
John.
|
|---|