/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 vote232 views1 answer
Winforms how to check for enter key
C#
0 vote197 views1 answer
How to write a ello world program in c#
C#
0 vote267 views1 answer
Hwo to prevent rotation after hitting an object in unity
C#
0 vote232 views1 answer
Asp.net issue
C#
1 vote219 views1 answer
Unity detect number key
C#
0 vote209 views1 answer
C# codebehind Append div
C#
0 vote227 views1 answer
Unity pickup and drop objects
C#
0 vote219 views1 answer
Why to make private fields readonly in c#
C#
1 vote207 views1 answer
Error inflating class android.support.constraint.ConstraintLayout
C#
0 vote244 views1 answer
Datatable linq where clause c#
C#