public string GetExcelColumnHeaderName(int ColumnNumber) {
//Max Length of Alfa char
int ColumnBase = 26;
int DigitMax = 4;
string AlfaChars = "ABCDEFGHIJKLMNOPQRSTUVWXYZ";
if (ColumnNumber <= 0) ColumnNumber = 1;
if (ColumnNumber <= ColumnBase) return AlfaChars[ColumnNumber - 1].ToString();
var CharCointainer = new StringBuilder().Append(' ', DigitMax);
var Current_Col_No = ColumnNumber;
var offset = DigitMax;
while (Current_Col_No > 0) {
CharCointainer[--offset] = AlfaChars[--Current_Col_No % ColumnBase];
Current_Col_No /= ColumnBase;
}
return CharCointainer.ToString(offset, DigitMax - offset);
}This code snippet demonstrates to get the excel column header name by providing column number to function.