Hi monks, I am parsing a couple of excel sheets which are arount 6MB capacity. The problem is that if i parse all these files (say 10 such files) then after extracting data from all the files the program does not exit even if it at the end of the program, it just hangs in there. When i see what exactly is happening using the unix top command then i see that this process is using almost 85 to 90% memory and is varying even after the program is ended (cpu usage = 1-2%). Can any body what exactly is happening and a solution to it. But if i parse them individually then there is no problem it uses limited memory and then the program exits early. I have one more query is there a way to split a single excel file into multiple ones using some perl module or some thing. Because i need to parse a file which is filled row wise and about 44 columns are filled. Hence i need to break this into two and then parse individually. Or can somebody suggest a way to convert a excel file into CSV(comma seperated values) format.

In reply to Problem parsing the excel sheet by Anonymous Monk

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.