/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

2 votes117 views1 answer
How to get specific length of row in matrix c#
C#
2 votes152 views1 answer
C# web api return image file
C#
23 votes124 views3 answers
How to write hello world in c#
C#
0 vote117 views1 answer
Windows form button image size
C#
0 vote117 views1 answer
.net return result encoding as utf8
C#
0 vote120 views1 answer
Gcm_sender_id convert text
C#
0 vote207 views1 answer
Uncapitalize string c#
C#
0 vote134 views1 answer
C# MD5.Create returning nul
C#
3 votes119 views2 answers
C# read file by line
C#
0 vote150 views1 answer
Wait in void update in unity
C#Unity