• Главная
• OfficeOpenXml
• ExcelWorkbook

C# Класс OfficeOpenXml.ExcelWorkbook

Показать файл Открыть проект Примеры использования класса

Private Properties

Свойство	Тип	Описание
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

Открытые методы

Метод	Описание
CreateVBAProject ( ) : void	Create an empty VBA project.

Приватные методы

Метод	Описание
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

Описание методов