/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 vote213 views1 answer
Randon C#
C#
0 vote203 views1 answer
C# How to change the text colour?
C#
0 vote252 views1 answer
C# how to debig
C#
0 vote205 views1 answer
C# entity framework get all records from table
C#
0 vote208 views1 answer
C# substring find word
C#
7 votes215 views2 answers
: ? operator in c#
C#
1 vote210 views1 answer
UnityEngine.Transform.get_position () (at <a0ef933b1aa54b668801ea864e4204fe>:0) Gamekit3D.MeleeWeapon.BeginAttack (System.Boolean thowingAttack)
C#
11 votes225 views4 answers
C# check if array contains value
C#
2 votes194 views1 answer
Find largest number in array c#
C#
0 vote209 views1 answer
Billboard canvas unity
C#