GrapeCity.Documents.Excel.CellInfo

Class CellInfo

Namespace

GrapeCity.Documents.Excel

Assembly

GcDocs.Excel.dll

Provide some helper functions.

public static class CellInfo

Inheritance

object

CellInfo

Inherited Members

object.ToString()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

Methods

CellIndexToName(int, int)

Gets cell name(address) according to its row and column indexes.

public static string CellIndexToName(int row, int column)

Parameters

row int

The row index.

column int

The column index.

Returns

string

The address of cell.

CellNameToIndex(string, out int, out int)

Gets cell row and column according to its name(address).

public static void CellNameToIndex(string name, out int row, out int column)

Parameters

name string

The cell name.

row int

The row index.

column int

The column index.

ColumnIndexToName(int)

Gets column name according to column index.

public static string ColumnIndexToName(int index)

Parameters

index int

The column index.

Returns

string

The name of column.

ColumnNameToIndex(string)

Gets column index according to column name.

public static int ColumnNameToIndex(string name)

Parameters

name string

The column name.

Returns

int

The index of column.

GetAccurateRangeBoundary(IRange)

Returns the position and size (in pixels) of the specified range.

public static RectangleF GetAccurateRangeBoundary(IRange range)

Parameters

range IRange

The range object.

Returns

System.Drawing.RectangleF

The RectangleF object.

GetRangeBoundary(IRange)

Returns the position and size (in pixels) of the specified range.

[Obsolete]
public static Rectangle GetRangeBoundary(IRange range)

Parameters

range IRange

The range object.

Returns

System.Drawing.Rectangle

RowIndexToName(int)

Gets row name according to row index.

public static string RowIndexToName(int index)

Parameters

index int

The row index.

Returns

string

The name of row.

RowNameToIndex(string)

Gets row index according to row name.

public static int RowNameToIndex(string name)

Parameters

name string

The row name.

Returns

int

The index of row.