How do I find the Excel column name that corresponds to a given integer? [duplicate]

by

I once wrote this function to perform that exact task:

public static string Column(int column)
{
    column--;
    if (column >= 0 && column < 26)
        return ((char)('A' + column)).ToString();
    else if (column > 25)
        return Column(column / 26) + Column(column % 26 + 1);
    else
        throw new Exception("Invalid Column #" + (column + 1).ToString());
}

More Related Contents:

  1. How can I pair socks from a pile efficiently?
  2. Unique (non-repeating) random numbers in O(1)?
  3. Getting the closest string match
  4. Converting a Uniform Distribution to a Normal Distribution
  5. Can hash tables really be O(1)?
  6. Graph Algorithm To Find All Connections Between Two Arbitrary Vertices
  7. How do you detect Credit card type based on number?
  8. What distribution do you get from this broken random shuffle?
  9. Is there an O(n) integer sorting algorithm?
  10. Determine font color based on background color
  11. Nearest neighbors in high-dimensional data?
  12. What algorithm gives suggestions in a spell checker?
  13. How can I measure the similarity between two images? [closed]
  14. Generate all unique substrings for given string
  15. How to efficiently build a tree from a flat structure?
  16. Sum-subset with a fixed subset size
  17. What is a good Hash Function?
  18. design a stack such that getMinimum( ) should be O(1)
  19. Binary Search in Array
  20. How to check if line segment intersects a rectangle?
  21. Calculate largest inscribed rectangle in a rotated rectangle
  22. The Sieve of Atkin
  23. How to partition an array of integers in a way that minimizes the maximum of the sum of each partition?
  24. 3 dimensional bin packing algorithms
  25. Iterating over a Binary Tree with O(1) Auxiliary Space
  26. Peak detection of measured signal
  27. “Rounding” colour values to the nearest of a small set of colours
  28. Tournament bracket placement algorithm
  29. How to convert decimal fractions to hexadecimal fractions?
  30. Best algorithm for matching colours.

Leave a Comment