/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

3 votes187 views1 answer
How to move your character in unity 2d game
C#Unity
0 vote158 views9 answers
C# return error status code based on exception
C#
6 votes184 views1 answer
How to generate entities from an existing database in entityframework core
C#
0 vote163 views1 answer
Find the values of dictionaries in C sharp
C#
1 vote138 views1 answer
C# change variable
C#
0 vote175 views1 answer
C# convert linq jValue to int
C#
0 vote157 views1 answer
C# beginform
C#
0 vote182 views1 answer
Unity customize hierarchy window
C#Unity
0 vote179 views2 answers
Datagridview mouse click event c#
C#
0 vote211 views1 answer
Lwjgl fullscreen
C#