Name Converter
The NameConverter is a static class that provides methods for name conversion (e.g. converting cell names to indexes and vice versa).
Methods
The following table lists the available methods:
| Method | Description |
|---|---|
ConvertRowIndexToName | Converts the row index to name. |
ConvertRowNameToIndex | Converts the row name to index. |
ConvertColumnIndexToName | Converts the column index to name. |
ConvertColumnNameToIndex | Converts the column name to index. |
ConvertCellIndexToName | Converts the cell index to name. |
TryConvertNamesToCellReferenceRangeExpression | Tries to convert the cell ranges names to cell reference ranges. |
ConvertCellReferenceToName | Converts the cell reference to name. |
ConvertCellRangeToName | Converts the cell range to a name. |
TryConvertNameToCellRange | Tries to convert the name to a cell range. |
ConvertCellIndexesToName | Converts the cell indexes to a name. |
ConvertCellNameToIndex | Converts the cell name to a cell index. |
TryConvertCellNameToIndex | Tries to convert the cell name to index. |
IsValidA1CellName | Determines whether the name of the cell is valid. |
Convert Row Index to Name
ConvertRowIndexToName method converts the row index to name.
Example 1:
int rowIndex = 0;
string rowName = NameConverter.ConvertRowIndexToName(rowIndex);Convert Row Name to Index
ConvertRowNameToIndex method converts the row name to index.
Example 2:
string rowName = "1";
int rowIndex = NameConverter.ConvertRowNameToIndex(rowName);Convert Column Index to Name
ConvertColumnIndexToName method converts the column index to name.
Example 3:
int columnIndex = 0;
string columnName = NameConverter.ConvertColumnIndexToName(columnIndex);Convert Column Name to Index
ConvertColumnNameToIndex converts the column name to index.
Example 4:
string columnName = "A";
int columnIndex = NameConverter.ConvertColumnNameToIndex(columnName);Convert Cell Index to Name
ConvertCellIndexToName method converts the cell index to name. This method exposes two overloads.
Example 5: first overload
CellIndex cellIndex = new CellIndex(rowIndex: 0, columnIndex: 0);
string cellName = NameConverter.ConvertCellIndexToName(cellIndex);Example 5: second overload
string cellName = NameConverter.ConvertCellIndexToName(rowIndex: 0, columnIndex: 0);Try Convert Names to Cell Reference Range Expression
TryConvertNamesToCellReferenceRangeExpression method tries to convert the cell ranges names to cell reference ranges.
Example 6:
string cellRangesName = "A1:F11";
Worksheet worksheet = workbook.ActiveWorksheet;
int rowIndex = 0;
int columnIndex = 0;
CellReferenceRangeExpression cellReferenceRangeExpression;
bool isConversionToCellReferenceRangeExpressionSuccessful = NameConverter.TryConvertNamesToCellReferenceRangeExpression(cellRangesName, worksheet, rowIndex, columnIndex, out cellReferenceRangeExpression);Convert Cell Reference to Name
ConvertCellReferenceToName method converts the cell reference to name.
Example 7:
CellReference fromCellReference = cellReferenceRangeExpression.CellReferenceRange.FromCellReference;
string fromCellReferenceName = NameConverter.ConvertCellReferenceToName(fromCellReference);
CellReference toCellReference = cellReferenceRangeExpression.CellReferenceRange.ToCellReference;
string toCellReferenceName = NameConverter.ConvertCellReferenceToName(toCellReference);Convert Cell Range to Name
ConvertCellRangeToName method converts the cell range to a name.
Example 8:
CellIndex fromIndex = new CellIndex(rowIndex: 0, columnIndex: 0);
CellIndex toIndex = new CellIndex(rowIndex: 10, columnIndex: 5);
string cellRangeName = NameConverter.ConvertCellRangeToName(fromIndex, toIndex);Try Convert Name to Cell Range
TryConvertNameToCellRange method converts the name to a cell range.
Example 9:
CellIndex fromIndex = new CellIndex(rowIndex: 0, columnIndex: 0);
CellIndex toIndex = new CellIndex(rowIndex: 10, columnIndex: 5);
string cellRangeName = NameConverter.ConvertCellRangeToName(fromIndex, toIndex);
CellRange cellRange;
bool result = NameConverter.TryConvertCellRangeNameToCellRange(cellRangeName, out cellRange);Convert Cell Indexes to Name
ConvertCellIndexesToName method converts the cell indexes to a name.
Example 10:
string cellRangeName = NameConverter.ConvertCellIndexesToName(fromRowIndex: 0, fromColumnIndex: 0, toRowIndex: 10, toColumnIndex: 5);Convert Cell Name to Index
ConvertCellNameToIndex method converts the cell name to a cell index. This method exposes two overloads.
Example 11: first overload
string cellName = "A1";
int rowIndex;
int columnIndex;
NameConverter.ConvertCellNameToIndex(cellName, out rowIndex, out columnIndex);Example 11: second overload
string cellName = "A1";
int rowIndex;
bool isRowAbsolute;
int columnIndex;
bool isColumnAbsolute;
NameConverter.ConvertCellNameToIndex(cellName, out isRowAbsolute, out rowIndex, out isColumnAbsolute, out columnIndex);Try Convert Cell Name to Index
TryConvertCellNameToIndex method tries to convert the cell name to index. This method exposes two overloads.
Example 12: first overload
string cellName = "A1";
int rowIndex;
int columnIndex;
bool isConversionSuccessful = NameConverter.TryConvertCellNameToIndex(cellName, out rowIndex, out columnIndex);Example 12: second overload
string cellName = "A1";
int rowIndex;
bool isRowAbsolute;
int columnIndex;
bool isColumnAbsolute;
bool isConversionSuccessful = NameConverter.TryConvertCellNameToIndex(cellName, out isRowAbsolute, out rowIndex, out isColumnAbsolute, out columnIndex);Is Valid A1 Cell Name
IsValidA1CellName method determines whether the name of the cell is valid.
Example 13:
string cellName = "B2";
bool isValidCellName = NameConverter.IsValidA1CellName(cellName);