/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

2 votes130 views3 answers
C# regex match
C#
0 vote134 views1 answer
Quaternion to euler
C#
0 vote155 views1 answer
How to draw gizmos unity
C#Unity
0 vote207 views1 answer
How to learn c# fast to learn unity
C#Unity
0 vote135 views2 answers
How to use file watcher in c#
C#
68 votes186 views3 answers
How to convert degrees to radians
C#
23 votes177 views2 answers
Unity serializefield
C#Unity
0 vote132 views1 answer
How many zeros in quinnonagintillion
C#
1 vote194 views1 answer
Unity 2d player move
C#Unity
0 vote127 views1 answer
[Package Manager Window] Error while fetching labels: User is not logged in or user status invalid. UnityEngine.GUIUtility:ProcessEvent (int,intptr,bool&)
C#