/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

28 votes178 views2 answers
Asp.net format datetime
C#
2 votes253 views1 answer
Wann war der dritte weltkrieg
C#
2 votes177 views1 answer
C# linq extension methods left join
C#
0 vote222 views1 answer
Générer un nombre aléatoire en c#
C#
0 vote200 views1 answer
Update squence c#
C#
-1 vote227 views1 answer
Unity move character with animation
C#Unity
8 votes219 views2 answers
How to get parent gameobject in unity
C#Unity
0 vote170 views1 answer
C# week refrences
C#
1 vote173 views1 answer
C# check if list contains string case insensitive
C#
28 votes199 views3 answers
Destroy gameobject unity
C#Unity