Threaded Comments

Threaded Comments

MS Excel 365 provides a feature to add threaded comments. These comments work as conversations and can be used for discussions. The comments now come with a Reply box that allows for threaded conversations. The old comments are called Notes in Excel 365. The screenshot below shows how threaded comments are displayed when opened in Excel.

Threaded comments are shown like this in older versions of Excel. The following images have been taken by opening the sample file in Excel 2016.

Aspose.Cells also provides the feature to manage threaded comments. 

Add Threaded Comments

Add Threaded comment with Excel

To add threaded comments in Excel 365, follow the following steps.

• Method 1
  • Click the Review Tab
  • Click the New Comment button
  • This will open a dialogue to enter comments in the active cell.
  • 
• Method 2
  • Right click on the cell where you want to insert the comment.
  • Click the New Comment option.
  • This will open a dialogue to enter comments in the active cell.
  • 

Add Threaded Comment using Aspose.Cells

Aspose.Cells provides Comments.AddThreadedComment method to add threaded comments.The Comments.AddThreadedComment method accepts the following three parameters.

• Cell Name: The name of the cell where the comment will be inserted.
• Comment Text: The text of the comment.
• ThreadedCommentAuthor: The author of the comment

The following code sample demonstrates the use of Comments.AddThreadedComment method to add threaded Comment to cell A1. Please see the output Excel file generated by the code for reference.

Sample Code

Read Threaded Comments

Read Threaded comments with Excel

To read threaded comments in Excel, simply hover your mouse over the cell containing comments to view the comments. The comments view will look like the view in the following image.

Read Threaded comments using Aspose.Cells

Aspose.Cells provides Comments.GetThreadedComments method to retrieve threaded comments for the specified column. Comments.GetThreadedComments method accepts the column name as a parameter and returns the ThreadedCommentCollection. You can iterate over the ThreadedCommentCollection to view the comments.

The following example demonstrates reading comments from column A1 by loading the sample Excel File. Please see the console output generated by the code for reference.

Sample Code

Console Output

Comment: Test Threaded Comment

Author: Aspose Test

Read Created Time of threaded comments

Aspose.Cells provides Comments.GetThreadedComments method to retrieve threaded comments for the specified column. Comments.GetThreadedComments method accepts the column name as a parameter and returns the ThreadedCommentCollection. You can iterate over the ThreadedCommentCollection and use the ThreadedComment.CreatedTime property.

The following example demonstrates reading the created time of threaded comments by loading the sample Excel File. Please see the console output generated by the code for reference.

Sample Code

Console Output

Comment: Test Threaded Comment

Author: Aspose Test

Created Time: 2019-05-15T12:46:23

Edit Threaded Comments

Edit Threaded comment with Excel

To edit a threaded comment in Excel, click the Edit link on the comment as shown in the following image.

Edit Threaded comment using Aspose.Cells

Aspose.Cells provides Comments.GetThreadedComments method to retrieve threaded comments for the specified column. Comments.GetThreadedComments method accepts the column name as a parameter and returns the ThreadedCommentCollection. You can update the required comment in the ThreadedCommentCollection and save the workbook.

The following example demonstrates editing the first threaded comment in column A1 by loading the sample Excel File. Please see the output Excel file generated by the code showing the updated comment for reference.

Sample Code

Remove Threaded Comments

Remove Threaded comments with Excel

To remove threaded comments in Excel, right click on the cell containing the comments and click the Delete Comment option as shown in the following image.

Remove Threaded comments using Aspose.Cells

Aspose.Cells provides Comments.RemoveAt method to remove comments for the specified column. Comments.RemoveAt method accepts the column name as a parameter removes the comments in that column. 

The following example demonstrates removing comments in column A1 by loading the sample Excel File. Please see the output Excel file generated by the code for reference.

Sample Code

Please note that by removing comment with Aspose.Cells, the author is not removed automatically. If you need to remove the author as well, please use the ThreadedCommentAuthorCollection.removeAt method as shown in the example above.