More than 26 columns

To get column letters !

protected function getColumnLetter( $number )
{
$prefix = '';
$prefNum = intval( $number/26 );
if( $prefNum > 0 )
{
$prefix = chr( $prefNum+64 );
$number = fmod( $number, 26 );
}

return $prefix.chr( $number+65 );
}

Regards

nice!

Oops, this works only for 26*26 columns !

Here is the function for infinite columns :

protected function getColumnLetter( $number )
{
$prefix = '';
$suffix = '';
$prefNum = intval( $number/26 );
if( $prefNum > 25 )
{
$prefix = $this->getColumnLetter( $prefNum % 26 );
}else{
}
if( $prefNum > 0 )
{
$prefix .= $this->getColumnLetter( $prefNum % 26 );
$suffix .= $this->getColumnLetter( fmod( $number, 26 ) );
}else{
$suffix .= chr( $number+65 );
}
return $prefix.$suffix;
}

Nope !

It jumps from AAZ to BBA !!! Grrrr...

I think I got it, more simple than I thought !

protected function getColumnLetter( $number )
{
$prefix = '';
$suffix = '';
$prefNum = intval( $number/26 );
if( $prefNum > 25 )
{
$prefix = $this->getColumnLetter( $prefNum );
}
$suffix = chr( fmod( $number, 26 )+65 );
return $prefix.$suffix;
}