Class ExcelDataProvider

Namespace

OfficeOpenXml.FormulaParsing

Assembly

Magicodes.EPPlus.dll

public abstract class ExcelDataProvider : IDisposable

Inheritance

object

ExcelDataProvider

Implements

IDisposable

Derived

EpplusExcelDataProvider

Inherited Members

object.GetType()

object.MemberwiseClone()

object.ToString()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

Extension Methods

ExtensionMethods.IsNumeric(object)

Constructors

ExcelDataProvider()

protected ExcelDataProvider()

Properties

ExcelMaxColumns

public abstract int ExcelMaxColumns { get; }

Property Value

int

ExcelMaxRows

public abstract int ExcelMaxRows { get; }

Property Value

int

Methods

Dispose()

public abstract void Dispose()

GetCellValue(string, int, int)

public abstract object GetCellValue(string sheetName, int row, int col)

Parameters

sheetName string

row int

col int

Returns

object

GetDimensionEnd(string)

public abstract ExcelCellAddress GetDimensionEnd(string worksheet)

Parameters

worksheet string

Returns

ExcelCellAddress

GetFormat(object, string)

public abstract string GetFormat(object value, string format)

Parameters

value object

format string

Returns

string

GetName(string, string)

public abstract ExcelDataProvider.INameInfo GetName(string worksheet, string name)

Parameters

worksheet string

name string

Returns

ExcelDataProvider.INameInfo

GetRange(string, int, int, int, int)

public abstract ExcelDataProvider.IRangeInfo GetRange(string worksheet, int fromRow, int fromCol, int toRow, int toCol)

Parameters

worksheet string

fromRow int

fromCol int

toRow int

toCol int

Returns

ExcelDataProvider.IRangeInfo

GetRange(string, int, int, string)

public abstract ExcelDataProvider.IRangeInfo GetRange(string worksheetName, int row, int column, string address)

Parameters

worksheetName string

row int

column int

address string

Returns

ExcelDataProvider.IRangeInfo

GetRange(string, string)

public abstract ExcelDataProvider.IRangeInfo GetRange(string worksheetName, string address)

Parameters

worksheetName string

address string

Returns

ExcelDataProvider.IRangeInfo

GetRangeFormula(string, int, int)

public abstract string GetRangeFormula(string worksheetName, int row, int column)

Parameters

worksheetName string

row int

column int

Returns

string

GetRangeFormulaTokens(string, int, int)

public abstract List<Token> GetRangeFormulaTokens(string worksheetName, int row, int column)

Parameters

worksheetName string

row int

column int

Returns

List<Token>

GetRangeValue(string, int, int)

public abstract object GetRangeValue(string worksheetName, int row, int column)

Parameters

worksheetName string

row int

column int

Returns

object

GetRangeValues(string)

public abstract IEnumerable<object> GetRangeValues(string address)

Parameters

address string

Returns

IEnumerable<object>

GetWorkbookNameValues()

public abstract ExcelNamedRangeCollection GetWorkbookNameValues()

Returns

ExcelNamedRangeCollection

GetWorksheetNames(string)

public abstract ExcelNamedRangeCollection GetWorksheetNames(string worksheet)

Parameters

worksheet string

Returns

ExcelNamedRangeCollection

IsRowHidden(string, int)

public abstract bool IsRowHidden(string worksheetName, int row)

Parameters

worksheetName string

row int

Returns

bool

Reset()

public abstract void Reset()