get excel row number code example
Example 1: excel vba get column name from number
'For column number 256...
ColName = Split(Cells(, 256).Address, "$")(1)
Example 2: 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;
}