C# Class OfficeOpenXml.ExcelStyles

Containts all shared cell styles for a workbook
Inheritance: XmlHelper
Show file Open project: pruiz/EPPlus Class Usage Examples

Public Properties

Property Type Description
Borders ExcelStyleCollection
CellStyleXfs ExcelStyleCollection
CellXfs ExcelStyleCollection
Dxfs ExcelStyleCollection
Fills ExcelStyleCollection
Fonts ExcelStyleCollection
NamedStyles ExcelStyleCollection
NumberFormats ExcelStyleCollection

Private Properties

Property Type Description
AddNamedStyle void
CloneStyle int
CloneStyle int
ExcelStyles System
GetStyleIdFromName int
GetStyleObject OfficeOpenXml.Style.ExcelStyle
GetXmlNode string
GetXmlNodeInt int
LoadFromDocument void
NamedStylePropertyChange int
PropertyChange int
RemoveUnusedStyles void
SetStyleAddress void

Public Methods

Method Description
CreateNamedStyle ( string name ) : OfficeOpenXml.Style.XmlAccess.ExcelNamedStyleXml
CreateNamedStyle ( string name, OfficeOpenXml.Style.ExcelStyle Template ) : OfficeOpenXml.Style.XmlAccess.ExcelNamedStyleXml
UpdateXml ( ) : void

Private Methods

Method Description
AddNamedStyle ( int id, XmlNode styleXfsNode, XmlNode cellXfsNode, OfficeOpenXml.Style.XmlAccess.ExcelNamedStyleXml style ) : void
CloneStyle ( ExcelStyles style, int styleID ) : int
CloneStyle ( ExcelStyles style, int styleID, bool isNamedStyle ) : int
ExcelStyles ( XmlNamespaceManager NameSpaceManager, XmlDocument xml, ExcelWorkbook wb ) : System
GetStyleIdFromName ( string Name ) : int
GetStyleObject ( int Id, int PositionID, string Address ) : OfficeOpenXml.Style.ExcelStyle
GetXmlNode ( XmlNode node ) : string
GetXmlNodeInt ( XmlNode node ) : int
LoadFromDocument ( ) : void

Loads the style XML to memory

NamedStylePropertyChange ( StyleBase sender, Style e ) : int

Handles property changes on Named styles.

PropertyChange ( StyleBase sender, Style e ) : int

Handels changes of properties on the style objects

RemoveUnusedStyles ( ) : void
SetStyleAddress ( StyleBase sender, Style e, ExcelAddressBase address, ExcelWorksheet ws, int>.Dictionary &styleCashe ) : void

Method Details

CreateNamedStyle() public method

public CreateNamedStyle ( string name ) : OfficeOpenXml.Style.XmlAccess.ExcelNamedStyleXml
name string
return OfficeOpenXml.Style.XmlAccess.ExcelNamedStyleXml

CreateNamedStyle() public method

public CreateNamedStyle ( string name, OfficeOpenXml.Style.ExcelStyle Template ) : OfficeOpenXml.Style.XmlAccess.ExcelNamedStyleXml
name string
Template OfficeOpenXml.Style.ExcelStyle
return OfficeOpenXml.Style.XmlAccess.ExcelNamedStyleXml

UpdateXml() public method

public UpdateXml ( ) : void
return void

Property Details

Borders public property

public ExcelStyleCollection Borders
return ExcelStyleCollection

CellStyleXfs public property

public ExcelStyleCollection CellStyleXfs
return ExcelStyleCollection

CellXfs public property

public ExcelStyleCollection CellXfs
return ExcelStyleCollection

Dxfs public property

public ExcelStyleCollection Dxfs
return ExcelStyleCollection

Fills public property

public ExcelStyleCollection Fills
return ExcelStyleCollection

Fonts public property

public ExcelStyleCollection Fonts
return ExcelStyleCollection

NamedStyles public property

public ExcelStyleCollection NamedStyles
return ExcelStyleCollection

NumberFormats public property

public ExcelStyleCollection NumberFormats
return ExcelStyleCollection