You used the debugger? Excellent. What did you find out? I think one very interesting question would be: How does the function know it is called the last time? Is it because you are at the last "page" of your excel file and there is some closing data missing? Or is it because some final cleanup damages your data? What happens if you read that file into Excel, maybe append some data and save it again ?

Can you rule out (through your debugging) the possibility that you feed the wrong data to the excel module on your last call of the function? If yes, the bug is not in the code you reproduced

You could also change the parameters of your graphs to see if there is some condition necessary to activate the bug. What happens if you don't do the last insert_chart?

PS: Did it occur to you that you didn't even tell us which CPAN module you use to create the graphs. Maybe there is only one and everybody knows it, but I wouldn't count on that.

In reply to Re^5: Excel editing perl by jethro
in thread Excel editing perl by tarunkhanna

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.