Class ExcelCellAddress

Namespace

OfficeOpenXml

Assembly

EPPlus.dll

A single cell address

public class ExcelCellAddress

Inheritance

object

ExcelCellAddress

Inherited Members

object.GetType()

object.MemberwiseClone()

object.ToString()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

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.