• Home
• OfficeOpenXml
• ExcelWorkbook

C# Class OfficeOpenXml.ExcelWorkbook

Mostra file Open project: pruiz/EPPlus Class Usage Examples

Private Properties

Property	Type	Description
AddPivotTable	void
ChangeContentTypeWorkbook	void
CodeNameChange	void
CreateWorkbookXml	void
DeleteCalcChain	void
ExcelDecodeString	string
ExcelEncodeString	void
ExcelWorkbook	System
ExistsNames	bool
ExistsPivotTableName	bool
ExistsTableName	bool
GetDefinedNames	void
GetExternalReferences	void
GetSharedStrings	void
Save	void
SetNameElement	void
UpdateDefinedNamesXml	void
UpdateSharedStringsXml	void
ValidateDataValidations	void

Public Methods

Method	Description
CreateVBAProject ( ) : void	Create an empty VBA project.

Private Methods

Method	Description
AddPivotTable ( string cacheID, Uri defUri ) : void
ChangeContentTypeWorkbook ( string contentType ) : void	Recreate the workbook part with a new contenttype
CodeNameChange ( string value ) : void
CreateWorkbookXml ( XmlNamespaceManager namespaceManager ) : void	Create or read the XML for the workbook.
DeleteCalcChain ( ) : void
ExcelDecodeString ( string t ) : string
ExcelEncodeString ( StreamWriter sw, string t ) : void	Return true if preserve space attribute is set.
ExcelWorkbook ( ExcelPackage package, XmlNamespaceManager namespaceManager ) : System	Creates a new instance of the ExcelWorkbook class.
ExistsNames ( ) : bool	Is their any names in the workbook or in the sheets.
ExistsPivotTableName ( string Name ) : bool
ExistsTableName ( string Name ) : bool
GetDefinedNames ( ) : void
GetExternalReferences ( ) : void
GetSharedStrings ( ) : void	Read shared strings to list
Save ( ) : void	Saves the workbook and all its components to the package. For internal use only!
SetNameElement ( ExcelNamedRange name, XmlElement elem ) : void
UpdateDefinedNamesXml ( ) : void
UpdateSharedStringsXml ( ) : void
ValidateDataValidations ( ) : void

Method Details