/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 vote320 views1 answer
Filter collection viewbag
C#
1 vote314 views1 answer
C# mongodb update multiple fields
C#
2 votes326 views2 answers
Ksi
C#
2 votes366 views2 answers
Unity get all components in gameobject
C#Unity
1 vote290 views1 answer
C# distinct array of objects by values
C#
1 vote317 views1 answer
C# method returns multiple values
C#
9 votes302 views1 answer
C# lambdas
C#
4 votes394 views1 answer
Unity new vector3
C#Unity
0 vote293 views1 answer
How to run code without a gameobject unity
C#
0 vote316 views1 answer
C# sprintf equivalent
C#