Re^2: Win32::OLE AddComment method and MS Office 2013

Yes.

$wsheet->Cells($row_num,$col_num)
[download]

is a defined Win32::OLE object. You can examine it in debugger and property 'Comment' is 'null' before and after call to AddComment. Docs for that call in 2003 and 2013 are the same. For now I used WriteExcel module as a quick workaround.

Comment on Re^2: Win32::OLE AddComment method and MS Office 2013 Download Code

Replies are listed 'Best First'.
Re^3: Win32::OLE AddComment method and MS Office 2013 by Anonymous Monk on Nov 11, 2014 at 00:09 UTC
s a defined Win32::OLE object. Yeah, it should always be a defined Win32::OLE object, because Cells() is documented to always return a Range ... even if the range is EMPTY	[reply]
Re^4: Win32::OLE AddComment method and MS Office 2013 by woland99 (Beadle) on Nov 11, 2014 at 23:54 UTC
I think I located the problem. My code was using modular approach - first add/modify spreadsheet content then a separate routine was adding/modifying comments. I think that there is some problem in the way I handle Excel object in between those two calls. If I combine writing out content and adding comments into one function then program works. Should be simple to debug now. Many thanks for all the answers!	[reply]