Class ExcelStyle
Toplevel class for cell styling
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 |
---|---|
Excel |
Font
Font styling
Declaration
public ExcelFont Font { get; set; }
Property Value
Type | Description |
---|---|
Excel |
Hidden
If true the formula is hidden when the sheet is protected. Protection
Declaration
public bool Hidden { get; set; }
Property Value
Type | Description |
---|---|
System. |
HorizontalAlignment
The horizontal alignment in the cell
Declaration
public ExcelHorizontalAlignment HorizontalAlignment { get; set; }
Property Value
Type | Description |
---|---|
Excel |
Indent
The margin between the border and the text
Declaration
public int Indent { get; set; }
Property Value
Type | Description |
---|---|
System. |
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. |
Numberformat
Numberformat
Declaration
public ExcelNumberFormat Numberformat { get; set; }
Property Value
Type | Description |
---|---|
Excel |
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. |
ReadingOrder
Readingorder
Declaration
public ExcelReadingOrder ReadingOrder { get; set; }
Property Value
Type | Description |
---|---|
Excel |
ShrinkToFit
Shrink the text to fit
Declaration
public bool ShrinkToFit { get; set; }
Property Value
Type | Description |
---|---|
System. |
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. |
VerticalAlignment
The vertical alignment in the cell
Declaration
public ExcelVerticalAlignment VerticalAlignment { get; set; }
Property Value
Type | Description |
---|---|
Excel |
WrapText
Wrap the text
Declaration
public bool WrapText { get; set; }
Property Value
Type | Description |
---|---|
System. |
XfId
The index in the style collection
Declaration
public int XfId { get; set; }
Property Value
Type | Description |
---|---|
System. |
Methods
SetTextVertical()
Makes the text vertically. This is the same as setting Text
Declaration
public void SetTextVertical()