How to delete cell's comment

[evgeny]

I have cell with comment.

How can i delete this comment?

Regards,

Evgeny Gusev

[Amjad_Sahi]

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.

[evgeny]

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

[Laurence]

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.

[Laurence]

Please try this attached version. This method is added.

[evgeny]

Thank you, Laurence

Comment was deleted with a charm.

I am very impressed you quick reaction.

Regards,

Evgeny Gusev