C# Class ExcelFormulaParser.Engine.ExcelDataProvider

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

Inheritance: IDisposable

Public Methods

Method	Description
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
return	void

Returns a single cell value

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

Returns a single cell value

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

Returns values from the required range.

public abstract GetRangeValues ( string address ) : IEnumerable
address	string	An Excel address
return	IEnumerable

Returns all formulas in a workbook

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

Returns all defined names in a workbook

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

Returns all formulas on a worksheet

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

Returns the names of all worksheet names

public abstract GetWorksheetNames ( ) : IEnumerable
return	IEnumerable

Sets the value on the cell

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