/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 vote189 views2 answers
C# turn negative number into positive
C#
31 votes190 views3 answers
Raycasting in unity
C#
1 vote189 views2 answers
Get connection string from web.config in c#
C#
14 votes421 views2 answers
Unity debug log gameobject
C#Unity
11 votes196 views3 answers
C sharp list of strings
C#
3 votes178 views1 answer
C# public 2d array
C#
1 vote202 views1 answer
C# alphabet array
C#
0 vote197 views1 answer
Selecting multiple columns with linq query and lambda expression
C#
3 votes194 views2 answers
C# ienumerable to list
C#
0 vote194 views1 answer
Create dropdown in datatable c# dynamically
C#