Xceed Workbooks for .NET v3.0 Documentation
Xceed.Workbooks.NET Assembly / Xceed.Workbooks.NET Namespace / ThreadCommentCollection Class
Example


In This Topic
    ThreadCommentCollection Class
    In This Topic
    Contains a collection of the various threads of Comments that can be found in the Worksheet.
    Syntax
    'Declaration
     
    
    <DefaultMemberAttribute("Item")>
    Public Class ThreadCommentCollection 
       Inherits WorksheetElement
    'Usage
     
    
    Dim instance As ThreadCommentCollection
    [DefaultMember("Item")]
    public class ThreadCommentCollection : WorksheetElement 
    Example
    using( var workbook = Workbook.Create( "AddComment.xlsx" ) ) 
      { 
        // Gets the first Worksheet; a Workbook always contains at least 1 Worksheet. 
        var worksheet = workbook.Worksheets[ 0 ]; 
    
        // Gets the annotations collection. 
        var annotations = worksheet.Annotations; 
    
        // Adds a Comment attached to Cell B1. 
        var comment = annotations.AddComment( "This is the title of the document", "B1" ); 
    
        // Replies to the Comment. 
        comment.Reply( "Wait I can also be in the thread of the conversation ?" ); 
    
        // Gets the thread of Comments. 
        var threadCommentCollection = annotations.Comments; 
    
        // Gets the number of Comments in the thread for Cell "B1". 
        var thread1_Count = threadCommentCollection[ "B1" ].Count; 
    
        // Saves Workbook to disk; 
        workbook.Save(); 
      }
    Inheritance Hierarchy

    System.Object
       Xceed.Workbooks.NET.WorkbookElement
          Xceed.Workbooks.NET.WorksheetElement
             Xceed.Workbooks.NET.ThreadCommentCollection

    Public Properties
     NameDescription
    Public PropertyGets the number of Comment threads in the current Worksheet.  
    Public PropertyOverloaded. Gets a thread of Comments.  
    Top
    Public Methods
     NameDescription
    Public Method  
    Top
    Supported Frameworks

    .NET: net5.0, net5.0-windows, net6.0, net6.0-macos, net6.0-windows, net7.0, net7.0-macos, net7.0-windows, net8.0, net8.0-browser, net8.0-macos, net8.0-windows, net9.0, net9.0-browser, net9.0-macos, net9.0-windows, net10.0, net10.0-browser, net10.0-macos, net10.0-windows.

    .NET Framework: net40, net403, net45, net451, net452, net46, net461, net462, net463, net47, net471, net472, net48, net481.

    See Also