XlPatternType Enum

Lists the types of patterns available for cell shading.

Namespace: DevExpress.Export.Xl

Assembly: DevExpress.Printing.v18.1.Core.dll

Declaration

C#

public enum XlPatternType

VB.NET

Public Enum XlPatternType

Members

Name	Description
None	No background (solid color or fill pattern) is applied to a cell.
Solid	Specifies that a cell is filled with a solid color.
MediumGray	Specifies the 50% gray pattern.
DarkGray	Specifies the 75% gray pattern.
LightGray	Specifies the 25% gray pattern.
DarkHorizontal	Specifies a pattern that is a series of thick horizontal stripes.
DarkVertical	Specifies a pattern that is a series of thick vertical stripes.
DarkDown	Specifies a pattern that is a series of thick downward diagonal stripes.
DarkUp	Specifies a pattern that is a series of thick upward diagonal stripes.
DarkGrid	Specifies the thick grid pattern.
DarkTrellis	Specifies the thick diagonal trellis pattern.
LightHorizontal	Specifies a pattern that is a series of thin horizontal stripes.
LightVertical	Specifies a pattern that is a series of thin vertical stripes.
LightDown	Specifies a pattern that is a series of thin downward diagonal stripes.
LightUp	Specifies a pattern that is a series of thin upward diagonal stripes.
LightGrid	Specifies the thin grid pattern.
LightTrellis	Specifies the thin diagonal trellis pattern.
Gray125	Specifies the 12.5% gray pattern.
Gray0625	Specifies the 6.25% gray pattern.

Related API Members

The following properties accept/return XlPatternType values:

• XlColorFilter.PatternType
• XlFill.PatternType

Remarks

To apply the pattern fill to a cell, call the XlFill.PatternFill method with the XlPatternType enumeration value passed as a parameter. To obtain or change the type of the applied pattern fill, use the XlFill.PatternType property.

Related GitHub Examples

The following code snippet (auto-collected from DevExpress Examples) contains a reference to the XlPatternType enum.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

C#

excel-export-api-examples-t253492/CS/XLExportExamples/SpreadsheetActions/CellFormattingActions.cs#L480

    // Specify the cell background pattern using predefined colors.
    cell.ApplyFormatting(XlFill.PatternFill(XlPatternType.DarkDown, Color.Red, Color.White));
}

VB.NET

excel-export-api-examples-t253492/VB/XLExportExamples/SpreadsheetActions/CellFormattingActions.vb#L478

    ' Specify the cell background pattern using predefined colors.
    cell.ApplyFormatting(XlFill.PatternFill(XlPatternType.DarkDown, Color.Red, Color.White))
End Using