/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 vote109 views1 answer
C# read file while writing
C#
-2 votes103 views1 answer
Random position unity 2d
C#
0 vote96 views2 answers
Last word of string to uppercase c#
C#
2 votes101 views2 answers
Bool
C#
0 vote134 views1 answer
How to have referecne to script in unity
C#Unity
7 votes114 views2 answers
: ? operator in c#
C#
2 votes100 views1 answer
Unity how to refrsh scene
C#
3 votes106 views2 answers
Get directory of file c#
C#
16 votes108 views2 answers
Import time C#
C#
0 vote150 views1 answer
Change color of object unity
C#Unity