/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 vote346 views2 answers
Sum the digits in c
C#
2 votes344 views2 answers
Commenting on C#
C#
-2 votes372 views1 answer
Unity multiplayer Photon
C#Unity
0 vote343 views1 answer
C# downloadstirng download old
C#
0 vote350 views1 answer
RelayCommand
C#
1 vote424 views1 answer
Unity how to set an objects postion x,y,z
C#Unity
0 vote356 views1 answer
Is keyboard clicked in Unity
C#Unity
7 votes344 views1 answer
For loop unity
C#
30 votes347 views3 answers
Check if file exist c#
C#
1 vote336 views1 answer
C# what is a question mark after a data type
C#