/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 vote315 views2 answers
C# list sort by property string
C#
0 vote370 views1 answer
Unity input get axis
C#Unity
33 votes332 views2 answers
C# array of strings
C#
13 votes371 views2 answers
How to make an object move in unity
C#Unity
1 vote328 views3 answers
Get application path c#
C#
0 vote347 views1 answer
Unity add explosion force
C#
0 vote355 views1 answer
C# webclient post file
C#
2 votes323 views3 answers
Unity remove parent
C#
0 vote326 views1 answer
C# if isset
C#
0 vote333 views1 answer
Web forms switch page
C#