/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 vote144 views1 answer
Hacking
C#
0 vote195 views1 answer
Loading screen unity
C#Unity
1 vote143 views3 answers
C# datetime now timestamp
C#
1 vote155 views1 answer
C# get logged on user name
C#
0 vote184 views1 answer
Get all components of type unity
C#Unity
15 votes151 views2 answers
Replace space with underscore in c#
C#
0 vote151 views1 answer
Bind repeater to dictionary
C#
2 votes155 views1 answer
C# create new thread
C#
0 vote154 views1 answer
.net new template
C#
1 vote151 views1 answer
C# socket connect timeout
C#