My Task: I have 15 excel files with n number of sheets in each excel file. these files have been put in a directory WEEK 1...WEEK N every week. i have three columns in each sheet having values of issue / start date / end date i would like to know the best way to find the following: 1. To calculate the number of days / issue in all the excel files. 2. To find out the issues closed since last update of the files. 3. To Plot issues opened / closed during a period of time. i heard this can be done by scripting. i have tried using VB Macros in excel in a different thread..it did help me to some extent. but since i am dealing with multiple files in a directory. and also i have compare results(open/close issues every week).i would like to if this could be achieved using perl and also please advise me the way to get started.

In reply to Scripting data extraction from excel files in a directory. by ark989

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.