Class ExcelCellAddress

A single cell address

Inheritance

object

ExcelCellAddress

Inherited Members

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

object.ReferenceEquals(object, object)

object.ToString()

Namespace: OfficeOpenXml

Assembly: EPPlus.dll

Syntax

public class ExcelCellAddress

Constructors

ExcelCellAddress()

Initializes a new instance of the ExcelCellAddress class.

Declaration

public ExcelCellAddress()

ExcelCellAddress(int, int, bool, bool)

Initializes a new instance of the ExcelCellAddress class.

Declaration

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

Parameters

Type	Name	Description
int	row	The row.
int	column	The column.
bool	isRowFixed	If the row is fixed, prefixed with $
bool	isColumnFixed	If the column is fixed, prefixed with $

ExcelCellAddress(string)

Initializes a new instance of the ExcelCellAddress class.

Declaration

public ExcelCellAddress(string address)

Parameters

Type	Name	Description
string	address	The address

Properties

Address

Celladdress

Declaration

public string Address { get; }

Property Value

Type	Description
string

Column

Column

Declaration

public int Column { get; }

Property Value

Type	Description
int

IsColumnFixed

Returns true if the column is fixed

Declaration

public bool IsColumnFixed { get; }

Property Value

Type	Description
bool

IsRef

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

Declaration

public bool IsRef { get; }

Property Value

Type	Description
bool

IsRowFixed

Returns true if the row is fixed

Declaration

public bool IsRowFixed { get; }

Property Value

Type	Description
bool

Row

Row

Declaration

public int Row { get; }

Property Value

Type	Description
int

Methods

GetColumnLetter(int)

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

Declaration

public static string GetColumnLetter(int column)

Parameters

Type	Name	Description
int	column	Index of the column (1-based)

Returns

Type	Description
string	The corresponding letter, like A for 1.