The Syncfusion .NET Excel (XlsIO) library offers comprehensive support for threaded comments, providing a structured and organized method for inserting, managing, and responding to annotations and discussions directly associated with specific cells in an Excel workbook.
This example code shows how to add threaded comments in an Excel workbook by using the Syncfusion .NET Excel Library and just a few lines of C# code.
// Initialize Excel engine and application
using ExcelEngine excelEngine = new ExcelEngine();
IApplication application = excelEngine.Excel;
application.DefaultVersion = ExcelVersion.Xlsx;
// Open an existing workbook
using FileStream inputStream = new FileStream("InputTemplate.xlsx", FileMode.Open, FileAccess.Read);
IWorkbook workbook = application.Workbooks.Open(inputStream);
IWorksheet worksheet = workbook.Worksheets[0];
// Add threaded comments
IThreadedComment threadedComment = worksheet.Range["H16"].AddThreadedComment("What is the reason for the higher total amount of \"desk\" in the west region?", "User1", DateTime.Now);
// Saving the Excel document
using FileStream outputStream = new FileStream("AddComment.xlsx", FileMode.Create, FileAccess.ReadWrite);
workbook.SaveAs(outputStream);Discover how threaded comments in the Syncfusion Excel Library improve collaboration by enabling users to easily add, manage, and track discussions within their workbooks.
Add threaded comments to specific cells, enabling discussions directly in the workbook.
Mark comments as resolved once discussions are complete.
Clear all comments from selected cells or the entire workbook when comments are no longer needed.
Discover valuable resources from our blog and documentation to enhance your efficiency in using thread comments.
Documentation
Documentation
Explore these resources for comprehensive guides, knowledge base articles, insightful blogs, and ebooks.
Product Updates
Technical Support
You can access a specific comment from the ThreadedComments collection of the workbook and get details such as text, author name, and creation time.
Yes, you can delete individual threaded comments or clear all existing threaded comments in a workbook by using the Syncfusion Excel Library. When deleting a threaded comment, all of its replies will be deleted automatically. You can also delete replies alone.
You can export threaded comments to PDF format with the Syncfusion Excel Library. This allows users to save Excel workbooks containing threaded comments as PDF documents, preserving collaborative discussions and annotations within the exported file.
You can add as many replies as needed.
You can mark a threaded comment as complete by changing the IsResolved property to True with the Syncfusion Excel Library. When marking a threaded comment as resolved, all its replies will be marked as resolved automatically. The resolved state is not applicable for reply comments alone.
Yes, the Syncfusion Excel Library supports threaded comments and notes in Excel workbooks.
Greatness—it’s one thing to say you have it, but it means more when others recognize it. Syncfusion® is proud to hold the following industry awards.
