C# Class OfficeOpenXml.ConditionalFormatting.ExcelConditionalFormattingValueObjectType

Functions related to the ExcelConditionalFormattingValueObject
Mostrar archivo Open project: ylatuya/EPPlus Class Usage Examples

Public Methods

Method Description
GetAttributeByType ( eExcelConditionalFormattingValueObjectType type ) : string

GetCfvoNodeByPosition ( eExcelConditionalFormattingValueObjectPosition position, eExcelConditionalFormattingRuleType ruleType, XmlNode topNode, XmlNamespaceManager nameSpaceManager ) : XmlNode

GetNodePathByNodeType ( eExcelConditionalFormattingValueObjectNodeType nodeType ) : string

GetOrderByPosition ( eExcelConditionalFormattingValueObjectPosition position, eExcelConditionalFormattingRuleType ruleType ) : int

Get the sequencial order of a cfvo/color by its position.
GetParentPathByRuleType ( eExcelConditionalFormattingRuleType ruleType ) : string

Get the cfvo (§18.3.1.11) node parent by the rule type. Can be any of the following: "colorScale" (§18.3.1.16); "dataBar" (§18.3.1.28); "iconSet" (§18.3.1.49)
GetTypeByAttrbiute ( string attribute ) : eExcelConditionalFormattingValueObjectType

Get the CFVO type by its @type attribute

Method Details

GetAttributeByType() public static method

public static GetAttributeByType ( eExcelConditionalFormattingValueObjectType type ) : string
type eExcelConditionalFormattingValueObjectType
return string

GetCfvoNodeByPosition() public static method

public static GetCfvoNodeByPosition ( eExcelConditionalFormattingValueObjectPosition position, eExcelConditionalFormattingRuleType ruleType, XmlNode topNode, XmlNamespaceManager nameSpaceManager ) : XmlNode
position eExcelConditionalFormattingValueObjectPosition
ruleType eExcelConditionalFormattingRuleType
topNode System.Xml.XmlNode
nameSpaceManager System.Xml.XmlNamespaceManager
return System.Xml.XmlNode

GetNodePathByNodeType() public static method

public static GetNodePathByNodeType ( eExcelConditionalFormattingValueObjectNodeType nodeType ) : string
nodeType eExcelConditionalFormattingValueObjectNodeType
return string

GetOrderByPosition() public static method

Get the sequencial order of a cfvo/color by its position.
public static GetOrderByPosition ( eExcelConditionalFormattingValueObjectPosition position, eExcelConditionalFormattingRuleType ruleType ) : int
position eExcelConditionalFormattingValueObjectPosition
ruleType eExcelConditionalFormattingRuleType
return int

GetParentPathByRuleType() public static method

Get the cfvo (§18.3.1.11) node parent by the rule type. Can be any of the following: "colorScale" (§18.3.1.16); "dataBar" (§18.3.1.28); "iconSet" (§18.3.1.49)
public static GetParentPathByRuleType ( eExcelConditionalFormattingRuleType ruleType ) : string
ruleType eExcelConditionalFormattingRuleType
return string

GetTypeByAttrbiute() public static method

Get the CFVO type by its @type attribute
public static GetTypeByAttrbiute ( string attribute ) : eExcelConditionalFormattingValueObjectType
attribute string
return eExcelConditionalFormattingValueObjectType