The only way that I can think of doing this would need a Windows system with Microsoft Office and Perl installed. In that scenario, you should be able to use Win32::OLE to be able to control Excel and Word via the OLE API.

The Win32::OLE module does have an OLE browser that you can use to try to figure out details about OLE objects (methods and properties). Personally, I've only gotten the browser code to work with using ActiveState's ActivePerl. Since the copyright of the module is owned by ActiveState, that might be the reason why.

The general technique for figuring out how to use Win32::OLE to automate office applications is to records a macros that does the desired task and then port that VB code into Perl code. In your situation, the task involves two different office applications, which could make this technique a bit more tricky to do. But I personally would probably still try this technique to see if it would help out.

In reply to Re: Copying Charts from Microsoft Excel to microsoft word by dasgar
in thread Copying Charts from Microsoft Excel to microsoft word by rohit1994

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.