<?xml version="1.0" encoding="windows-1252"?>
<node id="515489" title="Re: Printing extracted Excel data into a HTML table" created="2005-12-09 03:55:30" updated="2005-12-08 22:55:30">
<type id="11">
note</type>
<author id="103344">
Ryszard</author>
<data>
<field name="doctext">
My personal favourite is [cpan://HTML::Template] you can do something very simple like this (untested):
&lt;code&gt; 
&lt;table&gt;
  &lt;TMPL_LOOP NAME=FINANCIALS&gt;
    &lt;tr&gt;
      &lt;td&gt;&lt;TMPL_VAR NAME=SALES&gt;&lt;/td&gt;
      &lt;td&gt;&lt;TMPL_VAR NAME=Q1&gt;&lt;/td&gt;
      &lt;td&gt;&lt;TMPL_VAR NAME=Q2&gt;&lt;/td&gt;
    &lt;/tr&gt;
  &lt;/TMPL_LOOP&gt;
&lt;/table&gt;

$template-&gt;param(FINANCIALS =&gt; [ 
                                {
                                 SALES =&gt; "Low Power Components", 
                                 Q3    =&gt; 3000000, 
                                 Q4    =&gt; 4600000
                                },
                                {
                                 SALES =&gt; "Virtual Wire Products", 
                                 Q3    =&gt; 2700000,
                                 Q4    =&gt; 2300000
                                },
                               ]
                   );
&lt;/code&gt;

Its then relativly easy to loop thru your Excel output and create the array of hashes needed to fill the template.
&lt;p&gt;Then again, there is always [cpan://Text::Template] to use as well.. ;-)&lt;/p&gt;</field>
<field name="root_node">
515467</field>
<field name="parent_node">
515467</field>
</data>
</node>
