C# 클래스 ExcelFormulaParser.Engine.ExcelDataProvider

This class should be implemented to be able to deliver excel data to the formula parser.

상속: IDisposable

공개 메소드들

메소드	설명
Dispose ( ) : void	Use this method to free unmanaged resources.
GetCellValue ( int row, int col ) : ExcelCell	Returns a single cell value
GetCellValue ( string address ) : ExcelCell	Returns a single cell value
GetRangeValues ( string address ) : IEnumerable	Returns values from the required range.
GetWorkbookFormulas ( ) : string>.IDictionary	Returns all formulas in a workbook
GetWorkbookNameValues ( ) : object>.IDictionary	Returns all defined names in a workbook
GetWorksheetFormulas ( string sheetName ) : string>.IDictionary	Returns all formulas on a worksheet
GetWorksheetNames ( ) : IEnumerable	Returns the names of all worksheet names
SetCellValue ( string address, object value ) : void	Sets the value on the cell

Use this method to free unmanaged resources.

public abstract Dispose ( ) : void
리턴	void

Returns a single cell value

public abstract GetCellValue ( int row, int col ) : ExcelCell
row	int
col	int
리턴	ExcelCell

Returns a single cell value

public abstract GetCellValue ( string address ) : ExcelCell
address	string
리턴	ExcelCell

Returns values from the required range.

public abstract GetRangeValues ( string address ) : IEnumerable
address	string	An Excel address
리턴	IEnumerable

Returns all formulas in a workbook

public abstract GetWorkbookFormulas ( ) : string>.IDictionary
리턴	string>.IDictionary

Returns all defined names in a workbook

public abstract GetWorkbookNameValues ( ) : object>.IDictionary
리턴	object>.IDictionary

Returns all formulas on a worksheet

public abstract GetWorksheetFormulas ( string sheetName ) : string>.IDictionary
sheetName	string
리턴	string>.IDictionary

Returns the names of all worksheet names

public abstract GetWorksheetNames ( ) : IEnumerable
리턴	IEnumerable

Sets the value on the cell

public abstract SetCellValue ( string address, object value ) : void
address	string
value	object
리턴	void