Xceed Workbooks for .NET v2.0 Documentation
AnnotationCollection Class
Members  Example 


Xceed.Workbooks.NET Assembly > Xceed.Workbooks.NET Namespace : AnnotationCollection Class
Represents a collection of all the Notes and ThreadCommentCollections in the Worksheet.
Object Model
AnnotationCollection ClassAnnotation Class
Syntax
'Declaration
 
<DefaultMemberAttribute("Item")>
Public Class AnnotationCollection 
   Inherits WorksheetElement
'Usage
 
Dim instance As AnnotationCollection
[DefaultMember("Item")]
public class AnnotationCollection : WorksheetElement 
Remarks
This class also serves as the general access point to add and edit Comments in the Worksheet.
Example
using( var workbook = Workbook.Create( "AddNote.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 Note in Cell B1 with the name of the person who wrote it. 
    annotations.AddNote( new FormattedText( "This is the title of the document" ), "B1" ); 
    var annotationCount = annotations.Count; 

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

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

Requirements

Target Platforms: Windows 11, Windows 10, Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

See Also

Reference

AnnotationCollection Members
Xceed.Workbooks.NET Namespace