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 |