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


In This Topic
    FormattedTextList Class
    In This Topic
    Represents a list of FormattedText objects.
    Object Model
    FormattedTextList ClassFormattedText Class
    Syntax
    'Declaration
     
    
    <DefaultMemberAttribute("Item")>
    <DebuggerTypeProxyAttribute(System.Collections.Generic.Mscorlib_CollectionDebugView`1)>
    <DebuggerDisplayAttribute("Count = {Count}")>
    Public Class FormattedTextList 
       Inherits System.Collections.Generic.List(Of FormattedText)
    'Usage
     
    
    Dim instance As FormattedTextList
    [DefaultMember("Item")]
    [DebuggerTypeProxy(System.Collections.Generic.Mscorlib_CollectionDebugView`1)]
    [DebuggerDisplay("Count = {Count}")]
    public class FormattedTextList : System.Collections.Generic.List<FormattedText> 
    Example
    using( var workbook = Workbook.Create( "AddFormattedTextList.xlsx" ) ) 
      { 
        // Gets the first Worksheet; a Workbook always contains at least 1 Worksheet. 
        var worksheet = workbook.Worksheets[ 0 ]; 
    
        // Defines fonts. 
        var font1 = new Xceed.Workbooks.NET.Font() { Bold = true, Color = Color.Red }; 
        var font2 = new Xceed.Workbooks.NET.Font() { Italic = true, Color = Color.Blue }; 
    
        // Creates a FormattedTextList with 2 FormattedText. 
        var formattedTextList = new FormattedTextList(); 
        formattedTextList.Add( new FormattedText( "A formatted", font1 ) ); 
        formattedTextList.Add( new FormattedText( "Text List", font2 ) ); 
    
        // Sets the FormattedTextList in Cell A5. 
        worksheet.Cells[ "A5" ].Value = formattedTextList; 
    
        // Saves Workbook to disk; 
        workbook.Save(); 
      }
    Inheritance Hierarchy

    System.Object
       System.Collections.Generic.List<T>
          Xceed.Workbooks.NET.FormattedTextList

    Public Constructors
     NameDescription
    Public ConstructorOverloaded.   
    Top
    Public Properties
    Public Methods
     NameDescription
    Public Method (Inherited from System.Collections.Generic.List<FormattedText>)
    Public Method (Inherited from System.Collections.Generic.List<FormattedText>)
    Public Method (Inherited from System.Collections.Generic.List<FormattedText>)
    Public MethodOverloaded.  (Inherited from System.Collections.Generic.List<FormattedText>)
    Public Method (Inherited from System.Collections.Generic.List<FormattedText>)
    Public Method (Inherited from System.Collections.Generic.List<FormattedText>)
    Public Method (Inherited from System.Collections.Generic.List<FormattedText>)
    Public MethodOverloaded.  (Inherited from System.Collections.Generic.List<FormattedText>)
    Public Method  
    Public Method (Inherited from System.Collections.Generic.List<FormattedText>)
    Public Method (Inherited from System.Collections.Generic.List<FormattedText>)
    Public Method (Inherited from System.Collections.Generic.List<FormattedText>)
    Public MethodOverloaded.  (Inherited from System.Collections.Generic.List<FormattedText>)
    Public Method (Inherited from System.Collections.Generic.List<FormattedText>)
    Public MethodOverloaded.  (Inherited from System.Collections.Generic.List<FormattedText>)
    Public Method (Inherited from System.Collections.Generic.List<FormattedText>)
    Public MethodFormats a specific section of Text with a selected Font.  
    Public Method (Inherited from System.Collections.Generic.List<FormattedText>)
    Public Method  
    Public Method (Inherited from System.Collections.Generic.List<FormattedText>)
    Public MethodOverloaded.  (Inherited from System.Collections.Generic.List<FormattedText>)
    Public Method (Inherited from System.Collections.Generic.List<FormattedText>)
    Public Method (Inherited from System.Collections.Generic.List<FormattedText>)
    Public MethodOverloaded.  (Inherited from System.Collections.Generic.List<FormattedText>)
    Public Method (Inherited from System.Collections.Generic.List<FormattedText>)
    Public Method (Inherited from System.Collections.Generic.List<FormattedText>)
    Public Method (Inherited from System.Collections.Generic.List<FormattedText>)
    Public Method (Inherited from System.Collections.Generic.List<FormattedText>)
    Public MethodOverloaded.  (Inherited from System.Collections.Generic.List<FormattedText>)
    Public MethodOverloaded.  (Inherited from System.Collections.Generic.List<FormattedText>)
    Public Method (Inherited from System.Collections.Generic.List<FormattedText>)
    Public Method (Inherited from System.Collections.Generic.List<FormattedText>)
    Public Method (Inherited from System.Collections.Generic.List<FormattedText>)
    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