Sounds like you've already got a workable answer, but for the record, I've had a lot of luck constructing feature-rich Excel files using Excel and some sample data, and then saving them as XML.

Once you've got an Excel/XML file, it's not difficult to open in up and extrapolate the format and location of the data part of the file. Now you have a 'template' Excel document, and it's just a matter of substituting your data for the sample stuff, using whatever means you feel comfortable with. (Perl, PHP, XSLT, etc)

It's worth pointing out that although Excel names XML files '.xml', you can name them the usual '.xls' and Excel will open them just the same.

I make it sound straightforward, and it is, but do expect to spend some time ironing out bugs related to what formats and tags Excel expects.

Xaositect - Whitepages.com

In reply to Re: Creating Pivot tables from Perl by Xaositect
in thread Creating Pivot tables from Perl by narashima

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.