C# Class OfficeOpenXml.ConditionalFormatting.ExcelConditionalFormattingHelper

Conditional formatting helper
Mostra file Open project: pruiz/EPPlus Class Usage Examples

Public Methods

Method Description
CheckAndFixRangeAddress ( string address ) : string

Check and fix an address (string address)

ConvertFromColorCode ( string colorCode ) : Color

Convert a color code to Color Object

DecodeXML ( this s ) : string

Decode from XML (special characteres: ' " > < &)

EncodeXML ( this s ) : string

Encode to XML (special characteres: ' " > < &)

GetAttributeBool ( XmlNode node, string attribute ) : bool

GetAttributeBoolNullable ( XmlNode node, string attribute ) : bool?

GetAttributeDecimal ( XmlNode node, string attribute ) : decimal

GetAttributeDouble ( XmlNode node, string attribute ) : double

GetAttributeInt ( XmlNode node, string attribute ) : int

GetAttributeIntNullable ( XmlNode node, string attribute ) : int?

GetAttributeString ( XmlNode node, string attribute ) : string

Method Details

CheckAndFixRangeAddress() public static method

Check and fix an address (string address)
public static CheckAndFixRangeAddress ( string address ) : string
address string
return string

ConvertFromColorCode() public static method

Convert a color code to Color Object
public static ConvertFromColorCode ( string colorCode ) : Color
colorCode string Color Code (Ex. "#FFB43C53" or "FFB43C53")
return Color

DecodeXML() public static method

Decode from XML (special characteres: ' " > < &)
public static DecodeXML ( this s ) : string
s this
return string

EncodeXML() public static method

Encode to XML (special characteres: ' " > < &)
public static EncodeXML ( this s ) : string
s this
return string

GetAttributeBool() public static method

public static GetAttributeBool ( XmlNode node, string attribute ) : bool
node System.Xml.XmlNode
attribute string
return bool

GetAttributeBoolNullable() public static method

public static GetAttributeBoolNullable ( XmlNode node, string attribute ) : bool?
node System.Xml.XmlNode
attribute string
return bool?

GetAttributeDecimal() public static method

public static GetAttributeDecimal ( XmlNode node, string attribute ) : decimal
node System.Xml.XmlNode
attribute string
return decimal

GetAttributeDouble() public static method

public static GetAttributeDouble ( XmlNode node, string attribute ) : double
node System.Xml.XmlNode
attribute string
return double

GetAttributeInt() public static method

public static GetAttributeInt ( XmlNode node, string attribute ) : int
node System.Xml.XmlNode
attribute string
return int

GetAttributeIntNullable() public static method

public static GetAttributeIntNullable ( XmlNode node, string attribute ) : int?
node System.Xml.XmlNode
attribute string
return int?

GetAttributeString() public static method

public static GetAttributeString ( XmlNode node, string attribute ) : string
node System.Xml.XmlNode
attribute string
return string