What might be different about the XL2K format the ParseExcel stumbles over?

Excel 2000 has a option to store more than one Excel version in a file. You can see this in the "Save As" dialog as, for example, "Microsoft Excel 97-2000 & 5.0/95 Workbook (*.xls)".

If the workbook is saved in that format then Spreadsheet::ParseExcel may have to read the same data twice.

The other difference between Excel 95 and 2000 that might affect the parse speed is that in Excel 2000 all of the strings are stored in a hash table which may take a while to decode.

But these are just guesses. The only way to really find out is to use one of the profiling modules to try locate the bottlenecks. Although if you find a bottleneck in Spreadsheet::ParseExcel you probably won't find it easy to fix. ;-)

--
John.

In reply to Re: ParseExcel slow for XL2000? by jmcnamara
in thread ParseExcel slow for XL2000? by RandomWalk

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.