I need to assign a comment to a specific cell in a spreadsheet. I don't see how to pin a comment to a specific cell - all I have is the Comments.Add method to add a comment to the collection.
How can I assign "My Comment Here" to cell B23 on Sheet "MySheet"?
Using (yes) Automation, that would be something like this using an Excel Range object:
Moreover, the following document/article will give you complete reference on how to manage comments in Excel spreadsheet via Aspose.Cells APIs: Managing Comments