/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 vote230 views1 answer
Get unix time in seconds C#
C#
0 vote318 views1 answer
Cannot convert string to long c#
C#
8 votes273 views3 answers
C# combobox selectedvalue
C#
1 vote273 views2 answers
How to query items with any id in a list of ids linq c#
C#
1 vote237 views1 answer
Change partial view based on select asp.net core
C#
2 votes270 views2 answers
Commenting on C#
C#
0 vote266 views1 answer
Dictionary namespace c#
C#
1 vote267 views3 answers
C# remove duplicates from list
C#
1 vote260 views1 answer
C# sort array
C#
1 vote342 views1 answer
Make an object disappear from a c# script unity
C#Unity