Xceed Logo
Shop
Xceed Workbooks for .NET v3.0 Documentation
Xceed.Workbooks.NET Assembly / Xceed.Workbooks.NET Namespace / Comment Class
Example


In This Topic
    Comment Class
    In This Topic
    This class represents a single Comment in a ThreadCommentCollection.
    Object Model
    Comment ClassPerson ClassCell ClassComment Class
    Syntax
    'Declaration
 

    Public Class Comment 
   Inherits Annotation
    'Usage
 

    Dim instance As Comment
    public class Comment : Annotation
    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 in Cell B1 and update its text. 
    var comment = annotations.AddComment( "This is the title", "B1" ); 
    comment.Text += " of the document"; 

    // Saves Workbook to disk; 
    workbook.Save(); 
  }
    Inheritance Hierarchy

    System.Object
       Xceed.Workbooks.NET.WorkbookElement
          Xceed.Workbooks.NET.WorksheetElement
             Xceed.Workbooks.NET.Annotation
                Xceed.Workbooks.NET.Comment

    Public Properties
     NameDescription
    Public PropertyAnnotationTypeOverridden. Gets the AnnotationType.  
    Public PropertyAuthorObject that represents the person who wrote the Note or the Comment. (Inherited from Xceed.Workbooks.NET.Annotation)
    Public PropertyCellReferenceRepresents the Cell in which the Note or the Comment is inserted. (Inherited from Xceed.Workbooks.NET.Annotation)
    Public PropertyDateTimeReturns the time at which the Comment was first written in the Workbook.  
    Public PropertyIsShownIndicates if the Annotation is visible or not when the Workbook is opened. (Inherited from Xceed.Workbooks.NET.Annotation)
    Public PropertyTextGets or sets the text that is displayed in the Comment.  
    Top
    Public Methods
     NameDescription
    Public MethodGetTypeCode  
    Public MethodReplyInserts a new Comment at the end of the ThreadCommentCollection.  
    Public MethodToBoolean  
    Public MethodToByte  
    Public MethodToChar  
    Public MethodToDateTime  
    Public MethodToDecimal  
    Public MethodToDouble  
    Public MethodToInt16  
    Public MethodToInt32  
    Public MethodToInt64  
    Public MethodToSByte  
    Public MethodToSingle  
    Public MethodToStringOverloaded.   
    Public MethodToType  
    Public MethodToUInt16  
    Public MethodToUInt32  
    Public MethodToUInt64  
    Top
    Protected Methods
     NameDescription
    Protected Internal MethodIsDirtyOverridden.   
    Protected MethodOnPropertyChanged (Inherited from Xceed.Workbooks.NET.Annotation)
    Protected Internal MethodSetIsDirtyOverridden.   
    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

    Reference

    Comment Members
    Xceed.Workbooks.NET Namespace

    Send Feedback