Class NameConverter

Provides methods for name conversion.

Inheritance

System.Object

NameConverter

Inherited Members

System.Object.ToString()

System.Object.Equals(System.Object)

System.Object.Equals(System.Object, System.Object)

System.Object.ReferenceEquals(System.Object, System.Object)

System.Object.GetHashCode()

System.Object.GetType()

System.Object.MemberwiseClone()

Namespace: Telerik.Windows.Documents.Spreadsheet.Utilities

Assembly: Telerik.Windows.Documents.Spreadsheet.dll

Syntax

public static class NameConverter

Methods

ConvertCellIndexesToName(Int32, Int32, Int32, Int32)

Converts the cell indexes to a name.

Declaration

public static string ConvertCellIndexesToName(int fromRowIndex, int fromColumnIndex, int toRowIndex, int toColumnIndex)

Parameters

System.Int32 fromRowIndex The start row index.

System.Int32 fromColumnIndex The start column index.

System.Int32 toRowIndex The end row index.

System.Int32 toColumnIndex The end column index.

Returns

System.String The name.

ConvertCellIndexToName(Int32, Int32)

Converts the cell index to name.

Declaration

public static string ConvertCellIndexToName(int rowIndex, int columnIndex)

Parameters

System.Int32 rowIndex Index of the row.

System.Int32 columnIndex Index of the column.

Returns

System.String The name.

ConvertCellIndexToName(CellIndex)

Converts the cell index to name.

Declaration

public static string ConvertCellIndexToName(CellIndex cellIndex)

Parameters

CellIndex cellIndex The cell index.

Returns

System.String The name.

ConvertCellNameToIndex(String, out Boolean, out Int32, out Boolean, out Int32)

Converts the cell name to a cell index.

Declaration

public static void ConvertCellNameToIndex(string cellName, out bool isRowAbsolute, out int rowIndex, out bool isColumnAbsolute, out int columnIndex)

Parameters

System.String cellName Name of the cell.

System.Boolean isRowAbsolute The value indicating whether the row is absolute.

System.Int32 rowIndex Index of the row.

System.Boolean isColumnAbsolute The value indicating whether the column is absolute.

System.Int32 columnIndex Index of the column.

ConvertCellNameToIndex(String, out Int32, out Int32)

Converts the cell name to a cell index.

Declaration

public static void ConvertCellNameToIndex(string cellName, out int rowIndex, out int columnIndex)

Parameters

System.String cellName Name of the cell.

System.Int32 rowIndex Index of the row.

System.Int32 columnIndex Index of the column.

ConvertCellRangeToName(CellIndex, CellIndex)

Converts the cell range to a name.

Declaration

public static string ConvertCellRangeToName(CellIndex fromIndex, CellIndex toIndex)

Parameters

CellIndex fromIndex From index.

CellIndex toIndex To index.

Returns

System.String The name.

ConvertCellRangeToName(CellRange)

Converts the cell range to a name.

Declaration

public static string ConvertCellRangeToName(CellRange range)

Parameters

CellRange range The range.

Returns

System.String The name.

ConvertCellReferenceRangeToName(CellReference, CellReference)

Converts a range defined between cell references to a name.

Declaration

public static string ConvertCellReferenceRangeToName(CellReference fromCellReference, CellReference toCellReference)

Parameters

CellReference fromCellReference The start cell reference.

CellReference toCellReference The end cell reference.

Returns

System.String The name.

ConvertCellReferenceToName(CellReference)

Converts the cell reference to name.

Declaration

public static string ConvertCellReferenceToName(CellReference cellReference)

Parameters

CellReference cellReference The cell reference.

Returns

System.String The name.

ConvertColumnIndexToName(Int32)

Converts the column index to name.

Declaration

public static string ConvertColumnIndexToName(int columnIndex)

Parameters

System.Int32 columnIndex Index of the column.

Returns

System.String The name.

ConvertColumnNameToIndex(String)

Converts the column name to index.

Declaration

public static int ConvertColumnNameToIndex(string columnName)

Parameters

System.String columnName Name of the column.

Returns

System.Int32 The index.

ConvertRowIndexToName(Int32)

Converts the row index to name.

Declaration

public static string ConvertRowIndexToName(int rowIndex)

Parameters

System.Int32 rowIndex Index of the row.

Returns

System.String The name.

ConvertRowNameToIndex(String)

Converts the row name to index.

Declaration

public static int ConvertRowNameToIndex(string rowName)

Parameters

System.String rowName Name of the row.

Returns

System.Int32 The index.

IsValidA1CellName(String)

Determines whether the name of the cell is valid.

Declaration

public static bool IsValidA1CellName(string cellName)

Parameters

System.String cellName Name of the cell.

Returns

System.Boolean The value indicating whether the name of the cell is valid.

TryConvertCellNameToIndex(String, out Boolean, out Int32, out Boolean, out Int32)

Tries to convert the cell name to index.

Declaration

public static bool TryConvertCellNameToIndex(string cellName, out bool isRowAbsolute, out int rowIndex, out bool isColumnAbsolute, out int columnIndex)

Parameters

System.String cellName Name of the cell.

System.Boolean isRowAbsolute The is row absolute.

System.Int32 rowIndex Index of the row.

System.Boolean isColumnAbsolute The is column absolute.

System.Int32 columnIndex Index of the column.

Returns

System.Boolean

TryConvertCellNameToIndex(String, out Int32, out Int32)

Tries to convert the cell name to index.

Declaration

public static bool TryConvertCellNameToIndex(string cellName, out int rowIndex, out int columnIndex)

Parameters

System.String cellName Name of the cell.

System.Int32 rowIndex Index of the row.

System.Int32 columnIndex Index of the column.

Returns

System.Boolean The value indicating whether the conversion was successful.

TryConvertCellRangeNameToCellRange(String, out CellRange)

Tries to convert a cell range name to a CellRange instance.

Declaration

public static bool TryConvertCellRangeNameToCellRange(string name, out CellRange cellRange)

Parameters

System.String name The cell range name.

CellRange cellRange The CellRange instance.

Returns

System.Boolean True if successful, otherwise False.

TryConvertNamesToCellReferenceRangeExpression(String, Worksheet, Int32, Int32, out CellReferenceRangeExpression)

Converts the cell ranges names to cell reference ranges.

Declaration

public static bool TryConvertNamesToCellReferenceRangeExpression(string cellRangesNames, Worksheet worksheet, int rowIndex, int columnIndex, out CellReferenceRangeExpression expression)

Parameters

System.String cellRangesNames The cell ranges names.

Worksheet worksheet The worksheet.

System.Int32 rowIndex The row index of the cell for which the expression is created.

System.Int32 columnIndex The column index of the cell for which the expression is created.

CellReferenceRangeExpression expression The expression.

Returns

System.Boolean True if converter successfuly, else false.