/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 vote310 views1 answer
Embergene
C#
1 vote313 views1 answer
Check if panel has controler c#
C#
1 vote244 views9 answers
Unity vector3.lerp
C#
0 vote296 views1 answer
How to make soft body OBJECT in unity
C#
0 vote314 views1 answer
C# and Arrow Keys
C#
11 votes293 views2 answers
Unity how to change rotation
C#
3 votes293 views2 answers
Uuid table laravel
C#
0 vote335 views1 answer
@using System,System.Core
C#
2 votes337 views2 answers
Largest element in array in c#
C#
0 vote324 views1 answer
Asp.net get most recent file in directory
C#