Since you're on Windows and it sounds like you have Excel installed, I'd suggest spending some time learning how to use Win32::OLE to directly control Excel via OLE. Once you get the hang of it, data retrieval from cells as well as writing data/formulas to cells become very easy. You'll want to use the OLE browser that comes with the Win32::OLE module. Also, you can record a macros and then look at it's source code to help figure out how to do more complicated tasks, such as graph creation/manipulation. Of course, both methods are giving you information in VB, which you'll need to convert to Perl. Also, you'll want to be doing some error trapping to help avoid creating orphaned Excel processes.

After doing a quick search on "win32 ole excel", there appears to be a number of perlmonks.org nodes covering using Win32::OLE to control Excel. That might be a good start with learning about that.

In reply to Re: reading xlsx files by dasgar
in thread reading xlsx files by earthfriendlyleaf

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.