/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 vote139 views1 answer
Mvc write to console
C#
1 vote108 views1 answer
Merge point of two list
C#
0 vote114 views1 answer
Top down movement unity
C#
0 vote144 views1 answer
Username and password into base64 encoding c#
C#
-1 vote121 views1 answer
C# unhandled exception in thread
C#
0 vote122 views2 answers
Openiddect ef core table not creating
C#
0 vote110 views1 answer
How to iterate between hour range in c#
C#
1 vote108 views1 answer
Dell
C#
1 vote124 views1 answer
Find word in string array c#
C#
0 vote123 views1 answer
How to make character respawn if touches sprite c#
C#