/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 vote248 views1 answer
C# hardcode datetime quoting
C#
0 vote278 views1 answer
Interpolate rotation unity3d
C#
1 vote213 views1 answer
Unity ui get the canvas
C#Unity
0 vote259 views1 answer
Unity sprite blurry when far
C#Unity
1 vote231 views1 answer
Hcf of numbers
C#
3 votes227 views2 answers
C# get path without filename
C#
2 votes214 views1 answer
How to change the position of a gameobject in c# unity
C#
6 votes237 views6 answers
C# application exit
C#
0 vote232 views1 answer
C# core linq savechanges invalid column name error while adding but not while updating
C#
0 vote225 views1 answer
Can't select ui in scene view unity
C#