XlCondFmtIconSetType Enum

Lists values that sets the icon set type for the icon set conditional format.

Namespace: DevExpress.Export.Xl

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

Declaration

C#

public enum XlCondFmtIconSetType

VB.NET

Public Enum XlCondFmtIconSetType

Members

Name	Description
Arrows3	Specifies the 3 arrows icon set.
ArrowsGray3	Specifies the 3 gray arrows icon set.
Flags3	Specifies the 3 flags icon set.
TrafficLights3	Specifies the 3 traffic lights icon set.
TrafficLights3Black	Specifies the 3 traffic lights (rimmed) icon set.
Signs3	Specifies the 3 signs icon set.
Symbols3	Specifies the 3 symbols icon set.
Symbols3Circled	Specifies the 3 symbols (circled) icon set.
Stars3	Specifies the 3 stars icon set.
Triangles3	Specifies the 3 triangles icon set.
Arrows4	Specifies the 4 arrows icon set.
ArrowsGray4	Specifies the 4 gray arrows icon set.
RedToBlack4	Specifies the 4 "red to black" icon set.
Rating4	Specifies the 4 ratings icon set.
TrafficLights4	Specifies the 4 traffic lights icon set.
Arrows5	Specifies the 5 arrows icon set.
ArrowsGray5	Specifies the 5 gray arrows icon set.
Rating5	Specifies the 5 ratings icon set.
Quarters5	Specifies the 5 quarters icon set.
Boxes5	Specifies the 5 boxes icon set.
NoIcons

Related API Members

The following properties accept/return XlCondFmtIconSetType values:

Library	Related API Members
Cross-Platform Class Library	XlCondFmtCustomIcon.IconSetType
	XlCondFmtRuleIconSet.IconSetType
WPF Controls	IconSetFormat.IconSetType

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the XlCondFmtIconSetType 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/ConditionalFormattingActions.cs#L632

XlCondFmtRuleIconSet rule = new XlCondFmtRuleIconSet();
rule.IconSetType = XlCondFmtIconSetType.Arrows3;
// Set the rule priority.

how-to-use-the-excel-export-api-to-perform-a-sales-analysis-t252486/CS/XLExportExample/Form1.cs#L382

XlCondFmtRuleIconSet rule5 = new XlCondFmtRuleIconSet();
rule5.IconSetType = XlCondFmtIconSetType.TrafficLights3;
formatting.Rules.Add(rule5);

VB.NET

excel-export-api-examples-t253492/VB/XLExportExamples/SpreadsheetActions/ConditionalFormattingActions.vb#L633

Dim rule As New XlCondFmtRuleIconSet()
rule.IconSetType = XlCondFmtIconSetType.Arrows3
' Set the rule priority.

how-to-use-the-excel-export-api-to-perform-a-sales-analysis-t252486/VB/XLExportExample/Form1.vb#L397

Dim rule5 As New XlCondFmtRuleIconSet()
rule5.IconSetType = XlCondFmtIconSetType.TrafficLights3
formatting.Rules.Add(rule5)