/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 vote128 views1 answer
Asp.net textarea disable resize
C#
4 votes108 views1 answer
How to see if they are aholding down a key unity
C#
0 vote116 views1 answer
Get mouse inpuit new input system
C#
0 vote129 views1 answer
How to call method in different project in c# visual studio
C#
3 votes145 views3 answers
Rigidbody2d unity
C#Unity
1 vote169 views1 answer
C# check internet connection easy
C#
24 votes158 views2 answers
How to destroy an object in unity
C#Unity
0 vote114 views1 answer
Ado stands for
C#
0 vote118 views1 answer
C# make a negative number positive
C#
2 votes145 views2 answers
How to destroy parent gameobject unity
C#Unity