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 : StyleBaseProperties
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 |
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()