/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

1 vote215 views1 answer
C# append textbox
C#
0 vote192 views1 answer
How to write a list to csv c#
C#
0 vote182 views1 answer
Passing _ as out variable c#
C#
0 vote176 views1 answer
Office open xml check if row is empty
C#
31 votes235 views5 answers
String to json c#
C#
3 votes213 views3 answers
C# convert split to list
C#
0 vote175 views1 answer
ENUM error codes all
C#
0 vote157 views1 answer
ASP.Net MVC 5 datalist event trap to perform action
C#
54 votes246 views10 answers
Throw new error(
C#
0 vote171 views1 answer
Unity sprite blurry when far
C#