Question

23

Convert numbers to letters beyond the 26 character alphabet

rated 0 times [ 24] [ 1] / answers: 1 / hits: 26640 / 13 Years ago, wed, november 23, 2011, 12:00:00

I'm creating some client side functions for a mappable spreadsheet export feature.

I'm using jQuery to manage the sort order of the columns, but each column is ordered like an Excel spreadsheet i.e. a b c d e......x y z aa ab ac ad etc etc

How can I generate a number as a letter? Should I define a fixed array of values? Or is there a dynamic way to generate this?

Answers

Only authorized users can answer the question. Please sign in first, or register a free account.

tayla

Add To Favorites

Follow

Total Points: 681

Total Questions: 102

Total Answers: 108

Location: Marshall Islands

Member since Tue, Sep 21, 2021

3 Years ago

tayla questions

1 Problem embedding tiktok video into angular 7

Fri, Mar 5, 21, 00:00, 3 Years ago

1 Lodash - How to merge two arrays of objects based on key?

Wed, Oct 28, 20, 00:00, 4 Years ago

1 Horizontal scroll bar is appearing after using slick slider in the webpage

Wed, Oct 21, 20, 00:00, 4 Years ago

1 Jest: `querySelector` returns null in test of a ReactJS component

Sat, Jul 4, 20, 00:00, 4 Years ago

1 setTimeout with Promises

Thu, Apr 9, 20, 00:00, 4 Years ago

View All

answered 13 Years ago keyonna · Accepted Answer

I think you're looking for something like this

    function colName(n) {

        var ordA = 'a'.charCodeAt(0);

        var ordZ = 'z'.charCodeAt(0);

        var len = ordZ - ordA + 1;

      

        var s = ;

        while(n >= 0) {

            s = String.fromCharCode(n % len + ordA) + s;

            n = Math.floor(n / len) - 1;

        }

        return s;

    }



// Example:



    for(n = 0; n < 125; n++)

            document.write(n + : + colName(n) + <br>);