C# Class ExcelFormulaParser.EPPlus.EPPlusExcelDataProvider

Inheritance: ExcelFormulaParser.Engine.ExcelDataProvider

Mostra file Open project: swmal/ExcelFormulaParser Class Usage Examples

Public Methods

Method	Description
Dispose ( ) : void
EPPlusExcelDataProvider ( ExcelPackage package ) : System
GetCellValue ( int row, int col ) : ExcelCell
GetCellValue ( string address ) : ExcelCell
GetRangeValues ( string address ) : IEnumerable
GetWorkbookFormulas ( ) : string>.IDictionary
GetWorkbookNameValues ( ) : object>.IDictionary
GetWorksheetFormulas ( string sheetName ) : string>.IDictionary
GetWorksheetNames ( ) : IEnumerable
SetCellValue ( string address, object value ) : void

Private Methods

Method	Description
SetCurrentWorksheet ( ExcelAddressInfo addressInfo ) : void

Method Details

Dispose() public method

public Dispose ( ) : void
return	void

EPPlusExcelDataProvider() public method

public EPPlusExcelDataProvider ( ExcelPackage package ) : System
package	OfficeOpenXml.ExcelPackage
return	System

GetCellValue() public method

public GetCellValue ( int row, int col ) : ExcelCell
row	int
col	int
return	ExcelCell

GetCellValue() public method

public GetCellValue ( string address ) : ExcelCell
address	string
return	ExcelCell

GetRangeValues() public method

public GetRangeValues ( string address ) : IEnumerable
address	string
return	IEnumerable

GetWorkbookFormulas() public method

public GetWorkbookFormulas ( ) : string>.IDictionary
return	string>.IDictionary

GetWorkbookNameValues() public method

public GetWorkbookNameValues ( ) : object>.IDictionary
return	object>.IDictionary

GetWorksheetFormulas() public method

public GetWorksheetFormulas ( string sheetName ) : string>.IDictionary
sheetName	string
return	string>.IDictionary

GetWorksheetNames() public method

public GetWorksheetNames ( ) : IEnumerable
return	IEnumerable

SetCellValue() public method

public SetCellValue ( string address, object value ) : void
address	string
value	object
return	void