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 for Python via .NET 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 for Python via .NET

Aspose.Cells for Python via .NET provides Comments.add_threaded_comment method to add threaded comments.The Comments.add_threaded_comment 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.add_threaded_comment 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 for Python via .NET

Aspose.Cells for Python via .NET provides Comments.get_threaded_comments method to retrieve threaded comments for the specified column. Comments.get_threaded_comments 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 for Python via .NET provides Comments.get_threaded_comments method to retrieve threaded comments for the specified column. Comments.get_threaded_comments method accepts the column name as a parameter and returns the ThreadedCommentCollection. You can iterate over the ThreadedCommentCollection and use the ThreadedComment.created_time 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: 5/15/2019 12:46:23 PM

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 for Python via .NET

Aspose.Cells for Python via .NET provides Comments.get_threaded_comments method to retrieve threaded comments for the specified column. Comments.get_threaded_comments 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