/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

2 votes218 views3 answers
Unity remove parent
C#Unity
1 vote172 views1 answer
Mvc 5 dropdownlist
C#
136 votes539 views6 answers
C# string to int
C#
9 votes178 views2 answers
How to access gameobject name
C#
-1 vote176 views1 answer
Entity framework id not auto increment
C#
0 vote247 views1 answer
Implementing Banner Ads Unity
C#Unity
0 vote165 views1 answer
How to decode Microsoft Local token in service
C#
1 vote167 views1 answer
C# int to hex
C#
0 vote157 views1 answer
Init stirng list c#
C#
4 votes179 views3 answers
Sum of digits in c#
C#