/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 vote204 views1 answer
Spring jar debug level running
C#
2 votes192 views1 answer
Blazor button onclick parameter
C#
29 votes291 views4 answers
Unity key detection
C#Unity
0 vote193 views1 answer
Fix autofill issue asp.net mvc
C#
1 vote185 views1 answer
Create a slider in the inspector C#
C#
0 vote173 views1 answer
Connect to a database and loop over a recordset in C#
C#
0 vote230 views1 answer
Unity how to get data of play session time in a text file?
C#Unity
0 vote200 views1 answer
Gameobject.Find in unityC#
C#
4 votes187 views1 answer
C# int max
C#
14 votes187 views2 answers
How to make multiplayer game in unity
C#