/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 vote241 views2 answers
C# parse string to xml
C#
21 votes258 views2 answers
Unity get distance between two objects
C#
4 votes241 views1 answer
Instantiate list C#
C#
1 vote261 views2 answers
C# calcualte proccess
C#
0 vote248 views1 answer
When creating a new boolean column in an existing table how to set the default value as true in c# models code first
C#
0 vote261 views1 answer
Unity color mix
C#Unity
1 vote231 views1 answer
C# dictionary get highest key
C#
0 vote273 views1 answer
C# builder pattern fluent example
C#
31 votes254 views5 answers
String to json c#
C#
0 vote273 views1 answer
How to download somthing from one drive unity
C#Unity