Convert number to base26 column string for excel. lang perl [duplicate]

Question

Possible Duplicate:
How to convert a column number (eg. 127) into an excel column (eg. AA)

How convert number to base26 column string for excel. lang perl

This is not rent-a-coder. You should be able to translate these few simple lines. — Svante
– Svante, Commented Jul 6, 2010 at 16:51

daxim · Accepted Answer · 2010-07-06 14:19:39Z

4

Number::Latin

answered Jul 6, 2010 at 14:19

daxim

39.3k4 gold badges71 silver badges135 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Zaid · Accepted Answer · 2010-07-06 15:20:47Z

2

If it's something quick and dirty, the following sub may be useful.

sub column2base26 {

    my $column = shift;
    die "Column $column must be positive" unless $column > 0;

    my $string = 'A';
    $string++ for 2..$column;
    return $string;
}

print column2base26($_), "\n" foreach (23, 15, 333);

# Output:
# W
# O
# LU

edited Jul 6, 2010 at 15:20

answered Jul 6, 2010 at 14:52

Zaid

37.2k16 gold badges89 silver badges159 bronze badges

Collectives™ on Stack Overflow

Convert number to base26 column string for excel. lang perl [duplicate]

2 Answers 2

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Linked

Related