Class EpplusExcelDataProvider

Inheritance

System.Object

ExcelDataProvider

EpplusExcelDataProvider

Implements

System.IDisposable

Inherited Members

System.Object.Equals(System.Object)

System.Object.Equals(System.Object, System.Object)

System.Object.GetHashCode()

System.Object.GetType()

System.Object.MemberwiseClone()

System.Object.ReferenceEquals(System.Object, System.Object)

System.Object.ToString()

Namespace: OfficeOpenXml.FormulaParsing

Assembly: EPPlus.dll

Syntax

public class EpplusExcelDataProvider : ExcelDataProvider, IDisposable

Constructors

EpplusExcelDataProvider(ExcelPackage)

Declaration

public EpplusExcelDataProvider(ExcelPackage package)

Parameters

Type	Name	Description
ExcelPackage	package

Properties

ExcelMaxColumns

Declaration

public override int ExcelMaxColumns { get; }

Property Value

Type	Description
System.Int32

Overrides

ExcelDataProvider.ExcelMaxColumns

ExcelMaxRows

Declaration

public override int ExcelMaxRows { get; }

Property Value

Type	Description
System.Int32

Overrides

ExcelDataProvider.ExcelMaxRows

Methods

Dispose()

Declaration

public override void Dispose()

Overrides

ExcelDataProvider.Dispose()

GetCellId(String, Int32, Int32)

Declaration

public override ulong GetCellId(string sheetName, int row, int col)

Parameters

Type	Name	Description
System.String	sheetName
System.Int32	row
System.Int32	col

Returns

Type	Description
System.UInt64

Overrides

ExcelDataProvider.GetCellId(String, Int32, Int32)

GetCellValue(String, Int32, Int32)

Declaration

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

Parameters

Type	Name	Description
System.String	sheetName
System.Int32	row
System.Int32	col

Returns

Type	Description
System.Object

Overrides

ExcelDataProvider.GetCellValue(String, Int32, Int32)

GetDimensionEnd(String)

Declaration

public override ExcelCellAddress GetDimensionEnd(string worksheet)

Parameters

Type	Name	Description
System.String	worksheet

Returns

Type	Description
ExcelCellAddress

Overrides

ExcelDataProvider.GetDimensionEnd(String)

GetExcelTable(String)

Declaration

public override ExcelTable GetExcelTable(string name)

Parameters

Type	Name	Description
System.String	name

Returns

Type	Description
ExcelTable

Overrides

ExcelDataProvider.GetExcelTable(String)

GetFormat(Object, String)

Declaration

public override string GetFormat(object value, string format)

Parameters

Type	Name	Description
System.Object	value
System.String	format

Returns

Type	Description
System.String

Overrides

ExcelDataProvider.GetFormat(Object, String)

GetName(String, String)

Declaration

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

Parameters

Type	Name	Description
System.String	worksheet
System.String	name

Returns

Type	Description
ExcelDataProvider.INameInfo

Overrides

ExcelDataProvider.GetName(String, String)

GetRange(String, Int32, Int32, Int32, Int32)

Declaration

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

Parameters

Type	Name	Description
System.String	worksheet
System.Int32	fromRow
System.Int32	fromCol
System.Int32	toRow
System.Int32	toCol

Returns

Type	Description
ExcelDataProvider.IRangeInfo

Overrides

ExcelDataProvider.GetRange(String, Int32, Int32, Int32, Int32)

GetRange(String, Int32, Int32, String)

Declaration

public override ExcelDataProvider.IRangeInfo GetRange(string worksheet, int row, int column, string address)

Parameters

Type	Name	Description
System.String	worksheet
System.Int32	row
System.Int32	column
System.String	address

Returns

Type	Description
ExcelDataProvider.IRangeInfo

Overrides

ExcelDataProvider.GetRange(String, Int32, Int32, String)

GetRange(String, String)

Declaration

[Obsolete("Please use GetRange(string, row, column, address)")]
public override ExcelDataProvider.IRangeInfo GetRange(string worksheet, string address)

Parameters

Type	Name	Description
System.String	worksheet
System.String	address

Returns

Type	Description
ExcelDataProvider.IRangeInfo

Overrides

ExcelDataProvider.GetRange(String, String)

GetRangeFormula(String, Int32, Int32)

Declaration

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

Parameters

Type	Name	Description
System.String	worksheetName
System.Int32	row
System.Int32	column

Returns

Type	Description
System.String

Overrides

ExcelDataProvider.GetRangeFormula(String, Int32, Int32)

GetRangeFormulaTokens(String, Int32, Int32)

Declaration

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

Parameters

Type	Name	Description
System.String	worksheetName
System.Int32	row
System.Int32	column

Returns

Type	Description
System.Collections.Generic.List<Token>

Overrides

ExcelDataProvider.GetRangeFormulaTokens(String, Int32, Int32)

GetRangeValue(String, Int32, Int32)

Declaration

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

Parameters

Type	Name	Description
System.String	worksheetName
System.Int32	row
System.Int32	column

Returns

Type	Description
System.Object

Overrides

ExcelDataProvider.GetRangeValue(String, Int32, Int32)

GetRangeValues(String)

Declaration

public override IEnumerable<object> GetRangeValues(string address)

Parameters

Type	Name	Description
System.String	address

Returns

Type	Description
System.Collections.Generic.IEnumerable<System.Object>

Overrides

ExcelDataProvider.GetRangeValues(String)

GetValue(Int32, Int32)

Declaration

public object GetValue(int row, int column)

Parameters

Type	Name	Description
System.Int32	row
System.Int32	column

Returns

Type	Description
System.Object

GetWorkbookNameValues()

Declaration

public override ExcelNamedRangeCollection GetWorkbookNameValues()

Returns

Type	Description
ExcelNamedRangeCollection

Overrides

ExcelDataProvider.GetWorkbookNameValues()

GetWorksheetIndex(String)

Declaration

public override int GetWorksheetIndex(string worksheetName)

Parameters

Type	Name	Description
System.String	worksheetName

Returns

Type	Description
System.Int32

Overrides

ExcelDataProvider.GetWorksheetIndex(String)

GetWorksheetNames(String)

Declaration

public override ExcelNamedRangeCollection GetWorksheetNames(string worksheet)

Parameters

Type	Name	Description
System.String	worksheet

Returns

Type	Description
ExcelNamedRangeCollection

Overrides

ExcelDataProvider.GetWorksheetNames(String)

GetWorksheets()

Declaration

public override IEnumerable<string> GetWorksheets()

Returns

Type	Description
System.Collections.Generic.IEnumerable<System.String>

Overrides

ExcelDataProvider.GetWorksheets()

IsExternalName(String)

Declaration

public override bool IsExternalName(string name)

Parameters

Type	Name	Description
System.String	name

Returns

Type	Description
System.Boolean

Overrides

ExcelDataProvider.IsExternalName(String)

IsHidden(Int32, Int32)

Declaration

public bool IsHidden(int row, int column)

Parameters

Type	Name	Description
System.Int32	row
System.Int32	column

Returns

Type	Description
System.Boolean

IsMerged(Int32, Int32)

Declaration

public bool IsMerged(int row, int column)

Parameters

Type	Name	Description
System.Int32	row
System.Int32	column

Returns

Type	Description
System.Boolean

IsRowHidden(String, Int32)

Declaration

public override bool IsRowHidden(string worksheetName, int row)

Parameters

Type	Name	Description
System.String	worksheetName
System.Int32	row

Returns

Type	Description
System.Boolean

Overrides

ExcelDataProvider.IsRowHidden(String, Int32)

Reset()

Declaration

public override void Reset()

Overrides

ExcelDataProvider.Reset()

Implements

System.IDisposable