/C#/C# get excel column number from letter

C# get excel column number from letter

public static int ColumnNameToIndex(string name)
{
  var upperCaseName = name.ToUpper();
  var number = 0;
  var pow = 1;
  for (var i = upperCaseName.Length - 1; i >= 0; i--)
  {
    number += (upperCaseName[i] - 'A' + 1) * pow;
    pow *= 26;
  }

  return number;
}

Source: stackoverflow.com

Similar codes

4 votes142 views1 answer
Unity cast int to float
C#Unity
0 vote117 views1 answer
Stuck.hypixel.net ip
C#
0 vote112 views1 answer
ASP.NET Web Forms TextBox
C#
0 vote111 views1 answer
Get all viewsheet revit api
C#
0 vote102 views2 answers
Get local position unity
C#
0 vote106 views2 answers
Unity 2d top down movement script
C#
32 votes116 views6 answers
Random String
C#
3 votes105 views1 answer
C# writeline
C#
0 vote99 views1 answer
Scaffold single table to model ef core
C#
0 vote103 views1 answer
Asp.net mvc 5 codefirst dropdown list
C#