Algorithm to get the excel-like column name of a number

by

Here’s a nice simple recursive function (Based on zero indexed numbers, meaning 0 == A, 1 == B, etc)…

function getNameFromNumber($num) {
    $numeric = $num % 26;
    $letter = chr(65 + $numeric);
    $num2 = intval($num / 26);
    if ($num2 > 0) {
        return getNameFromNumber($num2 - 1) . $letter;
    } else {
        return $letter;
    }
}

And if you want it one indexed (1 == A, etc):

function getNameFromNumber($num) {
    $numeric = ($num - 1) % 26;
    $letter = chr(65 + $numeric);
    $num2 = intval(($num - 1) / 26);
    if ($num2 > 0) {
        return getNameFromNumber($num2) . $letter;
    } else {
        return $letter;
    }
}

Tested with numbers from 0 to 10000…

More Related Contents:

  1. generate unqie life time random number for each number [closed]
  2. Count array by parse value of array
  3. i need a PHP code to find longest contiguous sequence of characters in the string
  4. Auto Increment ID’s of 4 digit
  5. How to implement authorization using a Telegram API?
  6. List of Big-O for PHP functions
  7. Speed difference in using inline strings vs concatenation in php5?
  8. How to generate all permutations of a string in PHP?
  9. Achieve hierarchy, Parent/Child Relationship in an effective and easy way
  10. PHP algorithm to generate all combinations of a specific size from a single set
  11. Speed difference in using inline strings vs concatenation in php5?
  12. Preserve key order (stable sort) when sorting with PHP’s uasort
  13. String with array structure to Array [duplicate]
  14. Fastest way to convert string to integer in PHP
  15. Is there any way to detect strings like putjbtghguhjjjanika?
  16. Generating random numbers without repeats
  17. Combinations, Dispositions and Permutations in PHP
  18. Coalesce function for PHP?
  19. algorithm that will take numbers or words and find all possible combinations
  20. PHP Objects vs Arrays — Performance comparison while iterating
  21. Why is Magento so slow? [closed]
  22. Calculating distance between zip codes in PHP
  23. SELECT COUNT() vs mysql_num_rows();
  24. Algorithm to get all possible string combinations from array up to certain length
  25. Difference between mt_rand() and rand()
  26. Grouping arrays in PHP
  27. PDO::rowCount VS COUNT(*)
  28. Optimizing Kohana-based Websites for Speed and Scalability
  29. recursive function to get all the child categories
  30. Which is faster? Constants, Variables or Variable Arrays

Leave a Comment