Xceed Logo
Shop
Xceed Workbooks for .NET v3.0 Documentation
[Root] / Xceed.Workbooks.NET Assembly / Xceed.Workbooks.NET Namespace / CellHelper Class / ConvertLetterToNumber Method

The letter or letters that will be converted.

This must correspond to one or more letters used by MS Excel to identify a Column.



In This Topic
    ConvertLetterToNumber Method
    In This Topic
    Converts letters into a numerical value.
    Syntax
    'Declaration
 

    Public Shared Function ConvertLetterToNumber( _
   ByVal letter As String _
) As Integer
    'Usage
 

    Dim letter As String
Dim value As Integer
 
value = CellHelper.ConvertLetterToNumber(letter)
    public static int ConvertLetterToNumber( 
   string letter
)

    Parameters

    letter

    The letter or letters that will be converted.

    This must correspond to one or more letters used by MS Excel to identify a Column.

    Return Value

    The number corresponding to the chosen letters.
    Remarks
    The letter and number correspondence is determined as follows: "A" is 0, "B" is 1, "C" is 2 and so on. Therefore, "AA" will correspond to "26", "AB" to 27, "AC" to 28 and so forth.
    Supported Frameworks

    .NET: net5.0, net5.0-windows, net6.0, net6.0-macos, net6.0-windows, net7.0, net7.0-macos, net7.0-windows, net8.0, net8.0-browser, net8.0-macos, net8.0-windows, net9.0, net9.0-browser, net9.0-macos, net9.0-windows, net10.0, net10.0-browser, net10.0-macos, net10.0-windows.

    .NET Framework: net40, net403, net45, net451, net452, net46, net461, net462, net463, net47, net471, net472, net48, net481.

    See Also

    Reference

    CellHelper Class
    CellHelper Members

    Send Feedback