Class ExcelCellAddress¶

Namespace: OfficeOpenXml
Assembly: EPPlus.dll

A single cell address

public class ExcelCellAddress

Inheritance¶

object ← ExcelCellAddress

Inherited Members¶

object.Equals(object?, object?)
object.Equals(object?)
object.GetHashCode()
object.GetType()
object.MemberwiseClone()
object.ReferenceEquals(object?, object?)
object.ToString()

Constructors¶

ExcelCellAddress()¶

Initializes a new instance of the ExcelCellAddress class.

public ExcelCellAddress()

ExcelCellAddress(int, int, bool, bool)¶

Initializes a new instance of the ExcelCellAddress class.

public ExcelCellAddress(int row, int column, bool isRowFixed = false, bool isColumnFixed = false)

Parameters¶

row int

The row.

column int

The column.

isRowFixed bool

If the row is fixed, prefixed with $

isColumnFixed bool

If the column is fixed, prefixed with $

ExcelCellAddress(string)¶

Initializes a new instance of the ExcelCellAddress class.

public ExcelCellAddress(string address)

Parameters¶

address string

The address

Properties¶

Address¶

Celladdress

public string Address { get; }

Property Value¶

string

Column¶

Column

public int Column { get; }

Property Value¶

int

IsColumnFixed¶

Returns true if the column is fixed

public bool IsColumnFixed { get; }

Property Value¶

bool

IsRef¶

If the address is an invalid reference (#REF!)

public bool IsRef { get; }

Property Value¶

bool

IsRowFixed¶

Returns true if the row is fixed

public bool IsRowFixed { get; }

Property Value¶

bool

Row¶

Row

public int Row { get; }

Property Value¶

int

Methods¶

GetColumnLetter(int)¶

Returns the letter corresponding to the supplied 1-based column index.

public static string GetColumnLetter(int column)

Parameters¶

column int

Index of the column (1-based)

Returns¶

string

The corresponding letter, like A for 1.