/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

5 votes349 views6 answers
Shuffle array c#
C#
0 vote326 views1 answer
ENUM error codes all
C#
10 votes319 views3 answers
Switch case in c# with multiple values
C#
2 votes331 views1 answer
Unity can't select move tool
C#
3 votes316 views1 answer
How do I print something in the console at the start of the game unity
C#
129 votes551 views6 answers
C# random generator
C#
0 vote320 views1 answer
Clock in wpf
C#
0 vote366 views1 answer
Unity iap
C#Unity
0 vote349 views1 answer
C# make file not read only
C#
0 vote297 views2 answers
C# download image from url
C#