/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 vote378 views2 answers
C# To Pascal Case
C#
9 votes373 views1 answer
Unity delete specific text in a string
C#Unity
21 votes350 views2 answers
Unity yield return
C#Unity
0 vote327 views2 answers
C# optional parameters
C#
0 vote362 views1 answer
Unity check if swipe not tap
C#Unity
0 vote352 views1 answer
How to set picturebox width with form width in c#
C#
0 vote325 views1 answer
How to show an arrya in c#
C#
0 vote345 views1 answer
Binaural generator
C#
0 vote391 views1 answer
Unity get max occurrence in list
C#Unity
0 vote331 views1 answer
Number to string ef example c#
C#