Brethren,

I'm using Spreadsheet::WriteExcel to convert plain text files of tabular data into Excel files and delivering them to the user's browser to either save to disk or open in Excel. It works perfectly for most users. (This really is an excellent module)

BUT, a small number of users report that the resulting file opens in Excel, but after just a few seconds Excel produces a "page fault" or an "access violation" and crashes. The one thing common to such users is Excel 97. Also, when a user with Excel 2000 opens such a file it works fine, and if they save it and then pass it to an Excel 97 user, the file opens alright but the column headings (which are in combined cells) are missing.

I read in John McNamara's article of Fall 2000 in The Perl Journal, that this was a problem in the original release of Spreadsheet::WriteExcel, but that it had been fixed. Having obtained and installed Spreadsheet::WriteExcel just a few months ago, I assume it was the latest version.

Might anyone have experience with such a thing? Mr. McNamara, are you out there?

In reply to Spreadsheet::WriteExcel crashing Excel97 by punchcard_bob

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.