/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 vote118 views1 answer
C# change all values in dictionary
C#
1 vote165 views1 answer
C# distinct array of objects by values
C#
1 vote146 views1 answer
How to lerp in c#
C#
0 vote162 views1 answer
Polymorphism in C#
C#
-2 votes161 views1 answer
How to reference a static variable from another script in unity
C#
0 vote219 views1 answer
VLC .net
C#
0 vote166 views1 answer
C# create and populate int list
C#
0 vote118 views0 answer
C#
0 vote209 views1 answer
Get random point in collider unity
C#Unity
0 vote186 views1 answer
Remove all array elements c#
C#