Loading...

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.