Clearing Comments

Aspose.Cells Product Family
,
1

Hi,

I think I may have asked about this before, but I thought I would double check.

Are there any plans to include a function that allows you to clear all the comments in a worksheet? And if so, do you have any idea when that feature may be implemented?

Thanks
-Steve

2

Hi Steve,

It will be availabe before the mid of next month. However, you can only clear all the comments as a whole, not a specific one.

3

@sstchur,
Aspose.Cells has replaced Aspose.Excel which is no more conintued now. You can work with comments in Excel file using Aspose.Cells and perform variety of operations like inserting and removing cell comments easily. Following example demonstrates this feature:

// Instantiating a Workbook object
Workbook workbook = new Workbook();

// Adding a new worksheet to the Workbook object
int sheetIndex = workbook.Worksheets.Add();

// Obtaining the reference of the newly added worksheet by passing its sheet index
Worksheet worksheet = workbook.Worksheets[sheetIndex];

// Adding a comment to "F5" cell
int commentIndex = worksheet.Comments.Add("F5");

// Accessing the newly added comment
Comment comment = worksheet.Comments[commentIndex];

// Setting the comment note
comment.Note = "Hello Aspose!";

//For clearing a comment
worksheet.Comments.RemoveAt(2);

// Saving the Excel file
workbook.Save("book1.out.xls");

You may visit the following articles for different type of comments and notes:

A free trial version of this new product is available here:
Aspose.Cells for .NET (Latest Version)

A runnable complete solution can be downloaded here to check exciting features of this new product without writing any code.