Documents for Excel .NET Edition | GCDocuments
Features / Styles
In This Topic
    Styles
    In This Topic

    GcExcel .NET allows you to format the cells in a spreadsheet with a set of styles that can be utilized to format cell appearance in individual worksheets for enhanced clarity and increased readability. A cell style includes characteristics such as fill (solid fill, gradient fill, pattern fill), fonts, borders, name style, and display format.

    Applying style in a worksheet involves following tasks.

    Some of the built-in styles in GcExcel .NET are listed below:

    Category Description Properties
    Number Format Cell number format. IRange.NumberFormat
    Alignment Horizontal and vertical alignment of cell content, indentation,text wrap, text rotation and text shrinking.

    IRange.AddIndent

    IRange.IndentLevel

    IRange.WrapText

    IRange.ShrinkToFit

    IRange.MergeCells

    IRange.ReadingOrder

    IRange.Orientation

    Font IRange.Font(IFont) IRange.Font(IFont)
    Borders Cell border line styles and colors. IRange.Borders(IBorders)
    Fill Cell pattern fill or gradient fill. IRange.Interior(IInterior)
    Protection Cell protection options (Locked and Hidden)

    IRange.Locked

    IRange.FormulaHidden

    Apart from the built-in styles, you can also create custom styles with description for individual cells or a range of cells in a worksheet where you can define all the style attributes and properties including font, font size, number format, alignment etc.