Manage Comments in Worksheet

This topic discusses adding, accessing and removing comments from worksheets. Comments are useful for adding notes or useful information for users who will work with the sheet. Developers have the flexibility to add comments to any cell of the worksheet.

Working with Comments

Adding Comments

To add a comment to worksheet, please follow the steps below:

1. Add the Aspose.Cells.GridWeb control to the Web Form.
2. Access the worksheet you’re adding comments to.
3. Add a comment to a cell.
4. Set a note for the new comment.

A comment has been added to the worksheet

Accessing Comments

To access a comment:

1. Access the cell that contains the comment.
2. Get the cell’s reference.
3. Pass the reference to the Comment collection’s to access the comment.
4. It’s now possible to modify the comment’s properties.

Removing Comments

To remove a comment:

1. Access the cell as explained above.
2. Use the Comment collection’s RemoveAt method to remove the comment.