"HTML form that will collect data via Perl into a Microsoft Excel file..." So, essentially, you have been tasked with two jobs: Do you see how these are separate and distinct tasks that do not necessarily have to be coupled in the way you have specified? Your solution will be much more flexible if you look at the Excel requirement as a reporting requirement rather than as a mandate to use Excel for data storage. Using an RDBMS, for instance, will suit you far better and more efficiently for the CGI portion. You can then write something that reads from that into Excel or CSV or XML or whatever...

Celebrate Intellectual Diversity

In reply to Re: CGI form to Excel file by InfiniteSilence
in thread CGI form to Excel file by jamesmkennedy

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.