/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 vote270 views1 answer
How to put double quotes in a string c#
C#
2 votes336 views2 answers
Inactive after active with press key unity
C#Unity
42 votes281 views5 answers
Qwerty
C#
1 vote306 views2 answers
C# remove all null from list
C#
3 votes281 views1 answer
C# how to open file explorer
C#
13 votes344 views3 answers
Print random number unity
C#Unity
5 votes292 views5 answers
Decimal c# 2 digits
C#
0 vote280 views1 answer
C# set cursor to loading and back
C#
0 vote262 views1 answer
C# how-to-download-image-from-url
C#
1 vote293 views1 answer
Unity temperature to colour
C#