Looking at the source, you should be able to access the tempfile name using $template->{tempfile}

#!/usr/bin/perl
use strict;
use Excel::Template::TT;
 
# some TT options
my $config = {
    INTERPOLATE => 1,
    EVAL_PERL   => 1,
};
 
# set variables for replacement
my $vars = 
  { host => {
      cmts => { name => 'name' },
      interfaces => [ {
        bundle    => 'bundle1',
        subBundle => 'subBundle1', 
        secondaries => [ {
          ipAddress  => '198.168.0.1',
          subnetMask => '255.255.255.0',
        },],},],},
};

# create object
my $template = Excel::Template::TT->new(
    filename => 'sample.xml',
    config   => $config,
    VARS     => $vars,
);

# xml template file created
my $xml = $template->{tempfile}; 
open IN,'<',$xml or die "$!";
print $_ for <IN>;
close IN;

$template->write_file('sample.xls');
system('excel sample.xls')
[download]

Hi poj, well I looked into the documentation ... I have to develop this reflex and look into the source code !

This is great news, I tried that piece of code and it's working out perfectly

Many thanks

Doesn't Excel::Template simply use an XML file as the template input? What's preventing you from accessing this in the normal way? John McNamara has produced a lot of tools over the years for making working with Excel in a perlish way simple, for example Excel::Writer::XLSX.

Hi marto, you're absolutely right. But since the template contains loop instructions, I'd like to be able to give the user a preview with some sample data. My objective is to use the XML of a sample template to display in a webpage. My actual XML template is not intelligible.

Edit : I forgot to mention, I'm using the wrapper Excel::Template::TT

<workbook>
  <worksheet name="Configuration"><format color="black">
    <row><bold><cell text="!!!!!!!!! [% host.cmts.name %] !!!!!!!!!!" 
+/></bold></row> 
    <row />
[% FOREACH int IN host.interfaces %]
    <row><cell text="interface ip-bundle [% int.bundle %].[% int.subBu
+ndle %]" /></row>
[%- FOREACH ip IN int.secondaries %]
    <row><cell text=" ip address [% ip.ipAddress %] [% ip.subnetMask %
+] secondary" /></row>
  [%- END %]
[% END %]
    <row />
    <row><bold><cell text="!!!!!!!!! END : [% host.cmts.name %] !!!!!!
+!!!!" /></bold></row>
   </format>
  </worksheet>
</workbook>
[download]