//数字行列转换成excel的字母+数字格式单元格位标,$cross—横,$vertical—竖
function num2excel($cross = 1, $vertical = 1) {
if (! is_numeric ( $cross ) || ! is_numeric ( $vertical )) {
return false;
}
//ord('A') = 65;ord('Z') = 90;因为A=1,所以要从64加起
$digit1 = $cross % 26;
$digit1 = $digit1?$digit1:26;
$digit2 = floor(($cross-$digit1)/26);
$sign = array(chr(64+$digit1));
if ($digit2){
array_unshift($sign,chr(64+$digit2));
}
$sign = implode('',$sign);
return $sign.(string)$vertical;
}
function num2excel($cross = 1, $vertical = 1) {
if (! is_numeric ( $cross ) || ! is_numeric ( $vertical )) {
return false;
}
//ord('A') = 65;ord('Z') = 90;因为A=1,所以要从64加起
$digit1 = $cross % 26;
$digit1 = $digit1?$digit1:26;
$digit2 = floor(($cross-$digit1)/26);
$sign = array(chr(64+$digit1));
if ($digit2){
array_unshift($sign,chr(64+$digit2));
}
$sign = implode('',$sign);
return $sign.(string)$vertical;
}