Class ExcelFill

The background fill of a cell

Inheritance

System.Object

StyleBase

ExcelFill

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 class ExcelFill : StyleBase

Properties

BackgroundColor

The background color

Declaration

public ExcelColor BackgroundColor { get; }

Property Value

Type	Description
ExcelColor

Gradient

Access to properties for gradient fill.

Declaration

public ExcelGradientFill Gradient { get; }

Property Value

Type	Description
ExcelGradientFill

PatternColor

The color of the pattern

Declaration

public ExcelColor PatternColor { get; }

Property Value

Type	Description
ExcelColor

PatternType

The pattern for solid fills.

Declaration

public ExcelFillStyle PatternType { get; set; }

Property Value

Type	Description
ExcelFillStyle

Methods

SetBackground(eThemeSchemeColor, ExcelFillStyle)

Set the background to a specific color and fillstyle

Declaration

public void SetBackground(eThemeSchemeColor color, ExcelFillStyle fillStyle = ExcelFillStyle.Solid)

Parameters

Type	Name	Description
eThemeSchemeColor	color	The theme color
ExcelFillStyle	fillStyle	The fillstyle. Default Solid

SetBackground(ExcelIndexedColor, ExcelFillStyle)

Set the background to a specific color and fillstyle

Declaration

public void SetBackground(ExcelIndexedColor color, ExcelFillStyle fillStyle = ExcelFillStyle.Solid)

Parameters

Type	Name	Description
ExcelIndexedColor	color	The indexed color
ExcelFillStyle	fillStyle	The fillstyle. Default Solid

SetBackground(Color, ExcelFillStyle)

Set the background to a specific color and fillstyle

Declaration

public void SetBackground(Color color, ExcelFillStyle fillStyle = ExcelFillStyle.Solid)

Parameters

Type	Name	Description
System.Drawing.Color	color	the color
ExcelFillStyle	fillStyle	The fillstyle. Default Solid