The official Excel VBA documention on the CommentsThreaded collection lists all the methods (Item()) as well as all the properties (Application, Count, Creator, and Parent) -- which all apply to the Collection as a whole. An individual element of that Collection would be a CommentThreaded object, with methods (AddReply(), Delete(), Next(), Previous(), and Text()) and properties (Application, Author, Creator, Date, Parent, and Replies).

When using OLE from Perl, you just have to change the syntax from the MS documentation showing VBA syntax, and use the equivalent syntax in Perl, for referencing elements of arrays or for calling a method or accessing a property on an object. I don't have Excel available anymore to test, but I believe it's just the simple $comment->AddReply("Current sales") (similar to the AddReply() example) or $comment->{Date} to get the Date of the particular $comment.

But the MS documentation for the Excel VBA interface is where you go to find all the methods and properties for any given object, even though you're using Perl instead of VBA.

In reply to Re: Excel OLE list of comments methnods by pryrt
in thread Excel OLE list of comments methnods by esr

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.