/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 vote125 views1 answer
C# override gethashcode
C#
0 vote159 views1 answer
AuthenticationTicket authenticationProperties C# .net
C#
5 votes123 views1 answer
Dns ttl meaning
C#
1 vote115 views2 answers
SQLite in Xamarin forms
C#
4 votes168 views1 answer
Unity how to copy something to the clipboard
C#Unity
0 vote123 views3 answers
Reporting Progress from Async Tasks c#
C#
3 votes121 views3 answers
How to move mouse with c#
C#
0 vote119 views1 answer
C# get custom attribute from property
C#
0 vote119 views1 answer
Npm install --save vue-route@n
C#
1 vote137 views1 answer
Avoid autocomplete input text asp.net
C#