/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 vote197 views1 answer
How to make build events always run visual studio
C#
1 vote231 views1 answer
Unity know when gameobject presed
C#Unity
1 vote193 views1 answer
C# new line in messagebox
C#
0 vote178 views1 answer
C# read huge file
C#
0 vote277 views3 answers
C# replace multiple characters
C#
0 vote197 views1 answer
How to call last string from text file C#
C#
3 votes229 views1 answer
Unity on mousewheel down
C#Unity
4 votes231 views3 answers
Unfreeze position in unity
C#Unity
0 vote191 views1 answer
C# filter non alphanumeric characters
C#
1 vote175 views3 answers
If else c#
C#