/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 vote91 views1 answer
C# find element by condition
C#
0 vote132 views2 answers
How to get the index of an element in a list in unity 5
C#Unity
0 vote90 views1 answer
Add variable to the beginning of a list c#
C#
5 votes89 views3 answers
How to move a gameobject to another object
C#
0 vote91 views1 answer
.net return result encoding as utf8
C#
0 vote92 views1 answer
Accord.io read .mat file
C#
1 vote108 views2 answers
Send type as argument c#
C#
1 vote94 views1 answer
Vscode not showing errors c#
C#
128 votes243 views6 answers
C# random number
C#
2 votes90 views2 answers
Get diff btw datetimes two C#
C#