Get column name in excel

Hello,
I have problems when i using this code : Convert.ToChar(65 + intColumnIndex).ToString()
I can get the column index in character but it support till 26 column, after column “Z” the character will become “[”. It must be “AA” like excel format
So any idea to made it support more than 26 column? please help.

Try this

or some other alternative from Marketplace

Cheers

@LucastoH - for greater than 26 you can write a if condition and say “A”+(yourcode above)

This will be good until AZ…

You can refer this post too…

omg, why i don’t know this one :smiley: thanks so much

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.