Class EpplusExcelDataProvider

Namespace

OfficeOpenXml.FormulaParsing

Assembly

Magicodes.EPPlus.dll

public class EpplusExcelDataProvider : ExcelDataProvider, IDisposable

Inheritance

object

ExcelDataProvider

EpplusExcelDataProvider

Implements

IDisposable

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

EpplusExcelDataProvider(ExcelPackage)

public EpplusExcelDataProvider(ExcelPackage package)

Parameters

package ExcelPackage

Properties

ExcelMaxColumns

public override int ExcelMaxColumns { get; }

Property Value

int

ExcelMaxRows

public override int ExcelMaxRows { get; }

Property Value

int

Methods

Dispose()

public override void Dispose()

GetCellValue(string, int, int)

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

Parameters

sheetName string

row int

col int

Returns

object

GetDimensionEnd(string)

public override ExcelCellAddress GetDimensionEnd(string worksheet)

Parameters

worksheet string

Returns

ExcelCellAddress

GetFormat(object, string)

public override string GetFormat(object value, string format)

Parameters

value object

format string

Returns

string

GetName(string, string)

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

Parameters

worksheet string

name string

Returns

ExcelDataProvider.INameInfo

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

public override 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 override ExcelDataProvider.IRangeInfo GetRange(string worksheet, int row, int column, string address)

Parameters

worksheet string

row int

column int

address string

Returns

ExcelDataProvider.IRangeInfo

GetRange(string, string)

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

Parameters

worksheet string

address string

Returns

ExcelDataProvider.IRangeInfo

GetRangeFormula(string, int, int)

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

Parameters

worksheetName string

row int

column int

Returns

string

GetRangeFormulaTokens(string, int, int)

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

Parameters

worksheetName string

row int

column int

Returns

List<Token>

GetRangeValue(string, int, int)

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

Parameters

worksheetName string

row int

column int

Returns

object

GetRangeValues(string)

public override IEnumerable<object> GetRangeValues(string address)

Parameters

address string

Returns

IEnumerable<object>

GetValue(int, int)

public object GetValue(int row, int column)

Parameters

row int

column int

Returns

object

GetWorkbookNameValues()

public override ExcelNamedRangeCollection GetWorkbookNameValues()

Returns

ExcelNamedRangeCollection

GetWorksheetNames(string)

public override ExcelNamedRangeCollection GetWorksheetNames(string worksheet)

Parameters

worksheet string

Returns

ExcelNamedRangeCollection

IsHidden(int, int)

public bool IsHidden(int row, int column)

Parameters

row int

column int

Returns

bool

IsMerged(int, int)

public bool IsMerged(int row, int column)

Parameters

row int

column int

Returns

bool

IsRowHidden(string, int)

public override bool IsRowHidden(string worksheetName, int row)

Parameters

worksheetName string

row int

Returns

bool

Reset()

public override void Reset()