Re^2: Get Excel column name for given decimal number


Perl: the Markov chain saw
	PerlMonks

Re^2: Get Excel column name for given decimal number

by Akshit (Novice)

on Mar 28, 2020 at 13:52 UTC ( #11114752=note: print w/replies, xml )

Need Help??

in reply to Re: Get Excel column name for given decimal number
in thread Get Excel column name for given decimal number

Thanks all, such nice ideas to come up with for my problem. I will take those ideas and try which is the best fit for my code.

Comment on Re^2: Get Excel column name for given decimal number

Replies are listed 'Best First'.

Re^3: Get Excel column name for given decimal number
by Tux (Canon) on Mar 28, 2020 at 16:07 UTC

Take into account that there is a real performance difference between the three methods, which especially shows for high column numbers:

            (warning: too few iterations for a reliable count)
              Rate getcolname  int2LATIN  col2label
getcolname 0.119/s         --      -100%      -100%
int2LATIN   31.4/s     26218%         --       -55%
col2label   68.9/s     57742%       120%         --
[download]

So if this is hot code, don't use johngg's version, however nice his solution is :)