Class ExcelStyle

Toplevel class for cell styling

Inheritance

System.Object

StyleBase

ExcelStyle

Inherited Members

System.Object.Equals(System.Object)

System.Object.Equals(System.Object, System.Object)

System.Object.GetHashCode()

System.Object.GetType()

System.Object.MemberwiseClone()

System.Object.ReferenceEquals(System.Object, System.Object)

System.Object.ToString()

Namespace: OfficeOpenXml.Style

Assembly: EPPlus.dll

Syntax

public sealed class ExcelStyle : StyleBase

Properties

Border

Border

Declaration

public Border Border { get; set; }

Property Value

Type	Description
Border

Fill

Fill Styling

Declaration

public ExcelFill Fill { get; set; }

Property Value

Type	Description
ExcelFill

Font

Font styling

Declaration

public ExcelFont Font { get; set; }

Property Value

Type	Description
ExcelFont

Hidden

If true the formula is hidden when the sheet is protected. Protection

Declaration

public bool Hidden { get; set; }

Property Value

Type	Description
System.Boolean

HorizontalAlignment

The horizontal alignment in the cell

Declaration

public ExcelHorizontalAlignment HorizontalAlignment { get; set; }

Property Value

Type	Description
ExcelHorizontalAlignment

Indent

The margin between the border and the text

Declaration

public int Indent { get; set; }

Property Value

Type	Description
System.Int32

JustifyLastLine

If the cells justified or distributed alignment should be used on the last line of text.

Declaration

public bool JustifyLastLine { get; set; }

Property Value

Type	Description
System.Boolean

Locked

If true the cell is locked for editing when the sheet is protected Protection

Declaration

public bool Locked { get; set; }

Property Value

Type	Description
System.Boolean

Numberformat

Numberformat

Declaration

public ExcelNumberFormat Numberformat { get; set; }

Property Value

Type	Description
ExcelNumberFormat

QuotePrefix

If true the cell has a quote prefix, which indicates the value of the cell is text.

Declaration

public bool QuotePrefix { get; set; }

Property Value

Type	Description
System.Boolean

ReadingOrder

Readingorder

Declaration

public ExcelReadingOrder ReadingOrder { get; set; }

Property Value

Type	Description
ExcelReadingOrder

ShrinkToFit

Shrink the text to fit

Declaration

public bool ShrinkToFit { get; set; }

Property Value

Type	Description
System.Boolean

TextRotation

Text orientation in degrees. Values range from 0 to 180 or 255. Setting the rotation to 255 will align text vertically.

Declaration

public int TextRotation { get; set; }

Property Value

Type	Description
System.Int32

VerticalAlignment

The vertical alignment in the cell

Declaration

public ExcelVerticalAlignment VerticalAlignment { get; set; }

Property Value

Type	Description
ExcelVerticalAlignment

WrapText

Wrap the text

Declaration

public bool WrapText { get; set; }

Property Value

Type	Description
System.Boolean

XfId

The index in the style collection

Declaration

public int XfId { get; set; }

Property Value

Type	Description
System.Int32

Methods

SetTextVertical()

Makes the text vertically. This is the same as setting TextRotation to 255.

Declaration

public void SetTextVertical()