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;
}