function int2Excel( $num)
{
$az = 26;
$m = (int)($num % $az);
$q = (int)($num / $az);
$letter = chr(ord('A') + $m);
if ($q > 0) {
return int2Excel($q - 1) . $letter;
}
return $letter;
}
function excel2Int($str) {
$num = 0;
$strArr = str_split($str, 1);
$lenght = count($strArr);
foreach ($strArr as $k => $v) {
$num += ((ord($v) - ord('A') + 1) * pow(26, $lenght - $k - 1));
}
return $num - 1;
}
var_dump(int2Excel(51));
var_dump(excel2Int("AZ"));die;