in reply to Win32::OLE Excel Extracting Comments

Comment is it's own object with a Text Method, but referencing the Text method in those docs, doesn't list it as applying to the comment object... weird huh? My guess is also $worksheet->{$range_one,$range_one}->Comment->Text() The reason I think yours may not have worked is because its a function of a Range of cells and not one cell if you try it with your range as 1 cell like i mentioned above... using say A1,A1 as your range, then maybe it would work.

Replies are listed 'Best First'.
Re: Re: Win32::OLE Excel Extracting Comments
by Nkuvu (Priest) on Oct 23, 2003 at 20:45 UTC
    According to the VB browser in Excel, the Cells function returns a "cell as Range". So it's returning a valid Range object, I think. I've used the Cells function every once in a while, although more often I use the Range function. But even specifying a single cell it works just fine.

    For example: I've frequently used the following to get a value: $value = $worksheet->Range("B1")->{Value}; and I get the same results from the code my $value = $worksheet->Cells(1,2)->{Value};