Class ExcelCellBase

Namespace

OfficeOpenXml

Assembly

Magicodes.EPPlus.dll

public abstract class ExcelCellBase

Inheritance

object

ExcelCellBase

Derived

ExcelAddressBase

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

ExcelCellBase()

protected ExcelCellBase()

Methods

GetAddress(int, bool, int, bool)

public static string GetAddress(int Row, bool AbsoluteRow, int Column, bool AbsoluteCol)

Parameters

Row int

AbsoluteRow bool

Column int

AbsoluteCol bool

Returns

string

GetAddress(int, int)

public static string GetAddress(int Row, int Column)

Parameters

Row int

Column int

Returns

string

GetAddress(int, int, bool)

public static string GetAddress(int Row, int Column, bool Absolute)

Parameters

Row int

Column int

Absolute bool

Returns

string

GetAddress(int, int, int, int)

public static string GetAddress(int FromRow, int FromColumn, int ToRow, int ToColumn)

Parameters

FromRow int

FromColumn int

ToRow int

ToColumn int

Returns

string

GetAddress(int, int, int, int, bool)

public static string GetAddress(int FromRow, int FromColumn, int ToRow, int ToColumn, bool Absolute)

Parameters

FromRow int

FromColumn int

ToRow int

ToColumn int

Absolute bool

Returns

string

GetAddress(int, int, int, int, bool, bool, bool, bool)

public static string GetAddress(int FromRow, int FromColumn, int ToRow, int ToColumn, bool FixedFromRow, bool FixedFromColumn, bool FixedToRow, bool FixedToColumn)

Parameters

FromRow int

FromColumn int

ToRow int

ToColumn int

FixedFromRow bool

FixedFromColumn bool

FixedToRow bool

FixedToColumn bool

Returns

string

GetAddressCol(int, bool)

public static string GetAddressCol(int Col, bool Absolute = false)

Parameters

Col int

Absolute bool

Returns

string

GetAddressRow(int, bool)

public static string GetAddressRow(int Row, bool Absolute = false)

Parameters

Row int

Absolute bool

Returns

string

GetColumnLetter(int)

protected static string GetColumnLetter(int iColumnNumber)

Parameters

iColumnNumber int

Returns

string

GetColumnLetter(int, bool)

protected static string GetColumnLetter(int iColumnNumber, bool fixedCol)

Parameters

iColumnNumber int

fixedCol bool

Returns

string

GetFullAddress(string, string)

public static string GetFullAddress(string worksheetName, string address)

Parameters

worksheetName string

address string

Returns

string

IsValidAddress(string)

public static bool IsValidAddress(string address)

Parameters

address string

Returns

bool

IsValidCellAddress(string)

public static bool IsValidCellAddress(string cellAddress)

Parameters

cellAddress string

Returns

bool

TranslateFromR1C1(string, int, int)

public static string TranslateFromR1C1(string value, int row, int col)

Parameters

value string

row int

col int

Returns

string

TranslateToR1C1(string, int, int)

public static string TranslateToR1C1(string value, int row, int col)

Parameters

value string

row int

col int

Returns

string