The data is being produced from a 'table' so must be put into some form that is acceptable to Excel. If this format can not be generated such that Excel understands it as required (and the old module can generate it like that) then agreed you can not use cvs. However as I don't know what format is required I felt it was a reasonable suggestion. From my experience of extracting data from DBs for import into Excel spreadsheets (thankfully limited!) cvs has worked reasonably well. This was only company internal though, so if you have external clients it could be more of a problem. But the new modules seem as though they will address the problem, so all's well.

In reply to Re^4: Need to generate excel having more than 70,000 records by Ish
in thread Need to generate excel having more than 70,000 records by gube

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.