Re: Excel cell commenting?

I was able to do this using Win32::OLE with the following code:
$Worksheet->Range("$column$row")->AddComment("Foo!");
where $Worksheet, $column, and $row are properly defined before the statement, of course.

Comment on Re: Excel cell commenting? Select or Download Code

Replies are listed 'Best First'.
Re^2: Excel cell commenting? by monir (Acolyte) on Aug 19, 2004 at 16:44 UTC
Hi, Where can I find the docuemntation on what methods are available for Excel? I tried AddComment and it worked. But I need molre functionalities like adding fill color, deleting comments etc. I tried: $Sheet->Range("c8:c8")->SetFill("Red"); and it failed. I read the Win32::OLE documentaiton but that does not give Excel specific methodd details. Regards, -Monir	[reply]