Spreadsheet::ParseExcel does not use Excel in any way so ultimately the problem is not an Excel issue (even if Excel is generating rubbish output). About the only way forward I can think of is to use Excel to create subsets of the problematic file in an attempt to isolate the issue to as small a test .xls file as possible that still demonstrates the issue then submit a bug report. In the process you may discover the construct in the spreadsheet that is causing grief and maybe can work around it.

It may help to add logging to cell_handler so you can see what the last cell was before things went pear shaped and can maybe diagnose the problem that way.

Another possibility is that your cell_handler code has an interesting bug in it leading to recursion (for example) or allocation of a huge data structure. It may help to trim your cell_handler code to a minimum that demonstrates the problem then post that.

True laziness is hard work

In reply to Re: ParseExcel difficulties by GrandFather
in thread ParseExcel difficulties by hill

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.