处理excel时,要把数字转为列标,参考热心网友代码,整理一个PHP版的。
很简洁
function numToChar($n){
$s = "";
while($n != 0){
$r = $n%26;
if($r == 0){
$ch = 'Z';
}
else{
$ch = chr($r-1+ord('A'));
}
$s = $ch.$s;
if($s[0] == 'Z'){
$n = $n/26-1;
}
else{
$n /= 26;
}
$n = intval($n);
}
return $s;
}