/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 vote260 views1 answer
Install Mono project on Ubuntu 20.04
C#
0 vote255 views1 answer
Rock paper scissors c#
C#
0 vote269 views1 answer
Oracle c# parameters wont work
C#
1 vote245 views1 answer
Unity agent does not move
C#
0 vote254 views1 answer
Two question marks together mean in C#
C#
47 votes269 views5 answers
Remove last character from string c#
C#
0 vote252 views1 answer
C# program that print charater from A to Z and it's corresponding number
C#
0 vote253 views1 answer
How to get last child of gameobject in unity
C#
0 vote277 views1 answer
Unity can't put tmpro in script
C#
1 vote278 views2 answers
C# set cursor pos
C#