/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 vote383 views1 answer
Sdl quit event not working multiple windows
C#
0 vote367 views1 answer
C# after while loop unreachable
C#
2 votes357 views1 answer
C# cancellationtoken example
C#
0 vote363 views3 answers
Binding on button c#
C#
3 votes406 views2 answers
How to delete folder with files on c#
C#
0 vote351 views1 answer
Unity string lowercase
C#
0 vote358 views1 answer
Startup c# class winform
C#
0 vote388 views1 answer
C# check if there is 5 mins space between two datestime
C#
0 vote345 views1 answer
C# words return first 20 items of array
C#
0 vote357 views1 answer
Unity get rid of mouse
C#