/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 vote148 views1 answer
Unity make a gambeobject array
C#
28 votes159 views2 answers
Writeline c#
C#
1 vote160 views1 answer
Unity how to ommit letters from a string
C#
1 vote185 views1 answer
C# making a folder
C#
4 votes161 views3 answers
C# clear an array
C#
1 vote142 views2 answers
Unity script wait
C#
0 vote157 views1 answer
How to save datagridview data to database in c# windows application
C#
0 vote140 views1 answer
How to do Employing defensive code in the UI to ensure that the current frame is the most top level window in c#
C#
1 vote181 views1 answer
C# socket bind to localhost
C#
0 vote171 views1 answer
Align String with Spaces [C#]
C#