I was looking for a good way to convert a number to the Excel column letter, for example:<\/p>\n
1 -> A
\n26 -> Z
\n27 -> AA
\n28 -> AB
\n800 -> ADT<\/p>\n
etc.<\/p>\n
After searching on Google, I could not find any algorithm I want. (The closest one can handle up to two letters, i.e., ZZ. It will crash if the number is too large.). So I ended up creating my own.<\/p>\n
Basically, you can think of this problem as a 26 based number conversion. Here is the php version. It should be pretty simple to convert it to a different language. Let me know if you have any problem.<\/p>\n
\r\nfunction columnLetter($c){\r\n\r\n $c = intval($c);\r\n if ($c < = 0) return '';\r\n\r\n $letter = '';\r\n \r\n while($c != 0){\r\n $p = ($c - 1) % 26;\r\n $c = intval(($c - $p) \/ 26);\r\n $letter = chr(65 + $p) . $letter;\r\n }\r\n \r\n return $letter;\r\n \r\n}\r\n\r\n\r\n<\/pre>\n\r\nUsage:\r\ncolumnLetter(1303618093); \/\/DERRICK\r\n<\/pre>\nNote that if you prefer lower cases rather than upper cases, you can simply replace 65 by 96 in the code.<\/p>\n
Enjoy~!<\/p>\n
–Derrick<\/p>\n
<\/p>\n","protected":false},"excerpt":{"rendered":"