Beefy Boxes and Bandwidth Generously Provided by pair Networks
Pathologically Eclectic Rubbish Lister
 
PerlMonks  

Re^3: Perl OLE Excel Sort By Color

by hdb (Monsignor)
on Jun 03, 2015 at 06:25 UTC ( [id://1128914]=note: print w/replies, xml ) Need Help??


in reply to Re^2: Perl OLE Excel Sort By Color
in thread Perl OLE Excel Sort By Color

May I offer a slightly more general alternative to your sub colIdToString:

sub colIdToString { my $col = shift; my $column = ""; while( $col ) { my $remainder = ($col-1) % 26 + 1; $column = chr( $remainder + 64 ).$column; $col -= $remainder; $col /= 26; } return $column; }

Replies are listed 'Best First'.
Re^4: Perl OLE Excel Sort By Color
by martinslmn (Novice) on Jun 03, 2015 at 09:57 UTC

    Thank You. It worked like a charm.

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://1128914]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others contemplating the Monastery: (9)
As of 2024-03-28 10:07 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found