/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 vote155 views1 answer
Set property of control on form by name
C#
0 vote182 views1 answer
.net core check if linux
C#
36 votes528 views5 answers
How to generate random number in unity
C#Unity
0 vote234 views1 answer
How to chceck for a tag in a trigger enter 2d unity
C#Unity
1 vote174 views1 answer
C# socket bind to dns name
C#
1 vote126 views1 answer
C# metodas duomenu paemimui veiksmams ir grazinimui
C#
2 votes140 views1 answer
Parse excel file to class object c#
C#
0 vote155 views1 answer
How to disable all other components in gameobject in unity
C#
0 vote156 views1 answer
C# find duplicate
C#
1 vote172 views1 answer
C# multi assignment
C#