ComponentOne Excel for .NET
C1.Excel Assembly / C1.Excel Namespace / XLStyle Class
Properties Methods

In This Topic
    XLStyle Class Members
    In This Topic

    The following tables list the members exposed by XLStyle.

    Public Constructors
     NameDescription
    Public ConstructorXLStyle ConstructorCreates a new instance of XLStyle and adds it to the specified C1XLBook.  
    Top
    Public Properties
     NameDescription
    Public PropertyAlignHorzGets or sets the horizontal alignment for this XLStyle.  
    Public PropertyAlignVertGets or sets the vertical alignment for this XLStyle.  
    Public PropertyBackColorGets or sets the background color for this XLStyle.  
    Public PropertyBackPatternGets or sets the background pattern for this XLStyle.  
    Public PropertyBorderBottomGets or sets the line style used to draw the bottom border.  
    Public PropertyBorderColorBottomGets or sets the color used to draw the bottom border.  
    Public PropertyBorderColorLeftGets or sets the color used to draw the left border.  
    Public PropertyBorderColorRightGets or sets the color used to draw the right border.  
    Public PropertyBorderColorTopGets or sets the color used to draw the top border.  
    Public PropertyBorderLeftGets or sets the line style used to draw the left border.  
    Public PropertyBorderRightGets or sets the line style used to draw the right border.  
    Public PropertyBorderTopGets or sets the line style used to draw the top border.  
    Public PropertyDiagonalGets or sets which diagonal lines to display (none, forward, backward).  
    Public PropertyDiagonalColorGets or sets the color used to draw the diagonal lines.  
    Public PropertyDiagonalStyleGets or sets the line style used to draw the diagonal lines.  
    Public PropertyDirectionGets or sets the context reading direction for this XLStyle.  
    Public PropertyFontGets or sets the font for this XLStyle.  
    Public PropertyForeColorGets or sets the foreground color for this XLStyle.  
    Public PropertyFormatGets or sets the format associated with this XLStyle.  
    Public PropertyIndentGets or sets the indent cell contents for this XLStyle.  
    Public PropertyIsAutoBackColorGets whether background color of this XLStyle is automatic.  
    Public PropertyLockedGets or sets whether the cell should be locked for editing when the XLSheet is protected.  
    Public PropertyPatternColorGets or sets the color of the background pattern for this XLStyle.  
    Public PropertyQuotePrefixGets or sets whether the cell text value should be with quote prefix (single quotation mark) or no.  
    Public PropertyRotationGets or sets the rotation for this XLStyle, in degrees.  
    Public PropertyShrinkToFitGets or sets whether this XLStyle causes cell contents to shrink to fit.  
    Public PropertyWordWrapGets or sets whether this XLStyle causes cell contents to wrap.  
    Top
    Public Methods
     NameDescription
    Public MethodCloneCreates a new XLStyle object that is a copy of the current instance.  
    Public Methodstatic (Shared in Visual Basic)ColorFromIndexGets standard palette color.  
    Public MethodEqualsDetermines whether two XLStyle objects are equivalent.  
    Public Methodstatic (Shared in Visual Basic)FormatDotNetToXLOverloaded. Converts a .NET-style format string into an Excel format string.  
    Public Methodstatic (Shared in Visual Basic)FormatJapaneseDateTimeConverts .NET-style format string to New Japanese Era.  
    Public Methodstatic (Shared in Visual Basic)FormatXLToDotNetOverloaded. Converts an Excel-style format string into a .NET-style format string.  
    Public MethodGetHashCodeServes as a hash function suitable for use in hashing algorithms and data structures like a hash table.  
    Public Methodstatic (Shared in Visual Basic)IndexFromColorSearch for the nearest color in the RGB space.  
    Public MethodSetBorderColorSets the border color for this XLStyle.  
    Public MethodSetBorderStyleSets the border style for this XLStyle.  
    Top
    See Also

    Reference

    XLStyle Class
    C1.Excel Namespace