• 홈
• OfficeOpenXml
• ExcelWorkbook

C# 클래스 OfficeOpenXml.ExcelWorkbook

파일 보기 프로젝트 열기: pruiz/EPPlus 1 사용 예제들

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

메소드 상세