Class ExcelAddressBase

Namespace

OfficeOpenXml

Assembly

Magicodes.EPPlus.dll

public class ExcelAddressBase : ExcelCellBase

Inheritance

object

ExcelCellBase

ExcelAddressBase

Derived

ExcelAddress

ExcelFormulaAddress

Inherited Members

ExcelCellBase.TranslateFromR1C1(string, int, int)

ExcelCellBase.TranslateToR1C1(string, int, int)

ExcelCellBase.GetColumnLetter(int)

ExcelCellBase.GetColumnLetter(int, bool)

ExcelCellBase.GetAddressRow(int, bool)

ExcelCellBase.GetAddressCol(int, bool)

ExcelCellBase.GetAddress(int, int)

ExcelCellBase.GetAddress(int, bool, int, bool)

ExcelCellBase.GetAddress(int, int, bool)

ExcelCellBase.GetAddress(int, int, int, int)

ExcelCellBase.GetAddress(int, int, int, int, bool)

ExcelCellBase.GetAddress(int, int, int, int, bool, bool, bool, bool)

ExcelCellBase.GetFullAddress(string, string)

ExcelCellBase.IsValidAddress(string)

ExcelCellBase.IsValidCellAddress(string)

object.GetType()

object.MemberwiseClone()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

Extension Methods

ExtensionMethods.IsNumeric(object)

Constructors

ExcelAddressBase(int, int, int, int)

public ExcelAddressBase(int fromRow, int fromCol, int toRow, int toColumn)

Parameters

fromRow int

fromCol int

toRow int

toColumn int

ExcelAddressBase(int, int, int, int, bool, bool, bool, bool)

public ExcelAddressBase(int fromRow, int fromCol, int toRow, int toColumn, bool fromRowFixed, bool fromColFixed, bool toRowFixed, bool toColFixed)

Parameters

fromRow int

fromCol int

toRow int

toColumn int

fromRowFixed bool

fromColFixed bool

toRowFixed bool

toColFixed bool

ExcelAddressBase(string)

public ExcelAddressBase(string address)

Parameters

address string

ExcelAddressBase(string, ExcelPackage, ExcelAddressBase)

public ExcelAddressBase(string address, ExcelPackage pck, ExcelAddressBase referenceAddress)

Parameters

address string

pck ExcelPackage

referenceAddress ExcelAddressBase

ExcelAddressBase(string, int, int, int, int)

public ExcelAddressBase(string worksheetName, int fromRow, int fromCol, int toRow, int toColumn)

Parameters

worksheetName string

fromRow int

fromCol int

toRow int

toColumn int

Fields

_address

protected string _address

Field Value

string

_addresses

protected List<ExcelAddress> _addresses

Field Value

List<ExcelAddress>

_end

protected ExcelCellAddress _end

Field Value

ExcelCellAddress

_fromCol

protected int _fromCol

Field Value

int

_fromColFixed

protected bool _fromColFixed

Field Value

bool

_fromRow

protected int _fromRow

Field Value

int

_fromRowFixed

protected bool _fromRowFixed

Field Value

bool

_start

protected ExcelCellAddress _start

Field Value

ExcelCellAddress

_table

protected ExcelTableAddress _table

Field Value

ExcelTableAddress

_toCol

protected int _toCol

Field Value

int

_toColFixed

protected bool _toColFixed

Field Value

bool

_toRow

protected int _toRow

Field Value

int

_toRowFixed

protected bool _toRowFixed

Field Value

bool

_wb

protected string _wb

Field Value

string

_ws

protected string _ws

Field Value

string

Properties

Address

public virtual string Address { get; }

Property Value

string

Columns

public int Columns { get; }

Property Value

int

End

public ExcelCellAddress End { get; }

Property Value

ExcelCellAddress

IsName

public bool IsName { get; }

Property Value

bool

Rows

public int Rows { get; }

Property Value

int

Start

public ExcelCellAddress Start { get; }

Property Value

ExcelCellAddress

Table

public ExcelTableAddress Table { get; }

Property Value

ExcelTableAddress

Methods

ChangeAddress()

protected virtual void ChangeAddress()

SetAddress(string)

protected void SetAddress(string address)

Parameters

address string

ToString()

public override string ToString()

Returns

string

Validate()

protected void Validate()