perlseeker27 has asked for the wisdom of the Perl Monks concerning the following question:

Hi Monks, I have a script that generates an excel(calling this as New) by reading data from multiple excel sheets(callinthese as all). Now, comments have been added to these sheets(all). I would like to read these comments from (all) and put them in the excel that is being generated by script(New). I searched and found spreadsheet::parseExcel.But it does not have any such information. Could you please help me with this at the ealiest?

Replies are listed 'Best First'.
Re: Read Cell Comments
by technojosh (Priest) on Sep 14, 2007 at 20:08 UTC
    I've always had success with:

    Win32::OLE::Const 'Microsoft Excel';

    CPAN link

    But I can't help much more than that, with the vague description you've given.

[reply]
[d/l]
Re: Read Cell Comments
by throop (Chaplain) on Sep 14, 2007 at 19:49 UTC
    Gentle Perlseeker27,

    When you say 'comments', are you meaning some columns called 'comments' in some of the Excel spreadsheets?

    Or a worksheet called 'Comments' with the Excel file? or what?

    throop

[reply]
Re: Read Cell Comments
by planetscape (Chancellor) on Sep 15, 2007 at 20:24 UTC

    Most likely you will need to use a module such as Win32::OLE, and reference the cell's comments using syntax such as (VBA):

    Rng.Comment.Text

    [download]

    where Rng is a Range object referring to a single cell.

    I think you might benefit from replies to the thread VBA to Perl; marto has some great links on translating VBA to Perl, and I've got a few references to some utilities as well.

    An indispensable site for all things Excel- and spreadsheet-related is the aptly-named Spreadsheet Page, by John Walkenbach.

    You may also wish to google for microsoft Excel MVPs, and extend your search from there.

    HTH,

    planetscape
[reply]
[d/l]
[select]
      Thanks a lot for your inputs..!
[reply]

Back to Seekers of Perl Wisdom