/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

1 vote127 views3 answers
C# string to hex
C#
2 votes133 views3 answers
C# make first letter uppercase
C#
0 vote141 views1 answer
Random in f#
C#
0 vote132 views1 answer
Iis services in asp.net
C#
0 vote139 views1 answer
Unity deactivate scripts in list
C#
0 vote139 views1 answer
.net core Enable-Migrations' is not recognized as the name of a cmdlet
C#
0 vote170 views1 answer
C# form set auto scale
C#
2 votes91 views1 answer
Unity overlapsphere
C#
0 vote133 views1 answer
Msbuild publish to folder command line .net
C#
0 vote146 views1 answer
C# get country code
C#