Get last column of Excel sheet in Alphanumeric form

Help
,
3

agree

their are two ways to do this :slight_smile:
One is by using Excel Formula
like for example =SUBSTITUTE(ADDRESS(1;colNum;4);“1”;“”)

and other is by mapping :slight_smile:

I have used second approach in past and it works :slight_smile:

int Column_Number= your column number(int);
string columnName = String.Empty;
int modulo;

while (dividend > 0)
{
    modulo = (Column_Number- 1) % 26;
    columnName = Convert.ToChar(65 + modulo).ToString() + columnName;
    dividend = (int)((Column_Number- modulo) / 26);
}

Regards…!!
AKsh