/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

0 vote142 views1 answer
Reload usercontol wpf
C#
0 vote144 views1 answer
Getting the ID of the element that fired an event
C#
1 vote136 views1 answer
Developer jokes
C#
0 vote134 views1 answer
Declarar lista c#
C#
11 votes137 views1 answer
Unity to integer
C#
0 vote145 views1 answer
Convert path to uri c#
C#
0 vote161 views1 answer
Select range in list c#
C#
0 vote131 views1 answer
A infinite loop in text box update ui c#
C#
0 vote146 views2 answers
Set background from C# wpf
C#
0 vote194 views1 answer
Unity PlayOneShoot Audio
C#Unity