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.