Free Support Forum - aspose.com

How to delete cell's comment

I have cell with comment.

How can i delete this comment?

Regards,

Evgeny Gusev

Hi,

Thanks for considering Aspose.

May the following code help you for your need:

Workbook wb = new Workbook();
wb.Open("d:\\test\\tst_Comments.xls");
//Retrieving all the comments from the first worksheet
Comments comments = wb.Worksheets[0].Comments;
//Delete the first comment.
comments.RemoveAt(0);
wb.Save("d:\\test\\tst_Comments_new.xls");
Thank you.

Hi,

thank you for quick replay, but the problem is:

How to remove comment from given cell (for example from cell "H12").

Regards,

Evgeny Gusev

We will add a new method: Comments.RemoveAt(string cellName). Then you can use the following code:

Comments.RemoveAt("H12");

It will be available in the start of next week.

Please try this attached version. This method is added.

Thank you, Laurence

Comment was deleted with a charm.

I am very impressed you quick reaction.

Regards,

Evgeny Gusev