While I'm sure this Spreadsheet::WriteExcel module may be a great way to do this (I don't know), don't underestimate Excel's ability to work with lowest-common-denominator data formats.

Excel (98 at least) has the ability of reading HTML files consisting of a <table> and reading all of that data into native Excel cells. It can also take a simple ASCII tab-delimited file and read it in as if it were a native file format. Neither of these options requires any explicit "import" commands. You may be able to simply send either of these file types to Excel by changing its MIME type (not sure what to change it to.. application/vnd.ms-excel or something) and likely its document extension (IE likes to ignore MIME types sometimes).

I know this doesn't completely address your question, but it is an alternative that might be easier to implement.

In reply to Re: CGI & Spreadsheet::WriteExcel Module Help needed by Fastolfe
in thread CGI & Spreadsheet::WriteExcel Module Help needed by BigGuy

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.