/**
* Notes: 数字生成字母,1=A开始
* @param int $num
* @return string
*/
function numToExcelLetter(int $num): string
{
$result = '';
while ($num > 0) {
$mod = $num % 26;
$num = (int)($num / 26);
if ($mod == 0) {
$num --;
$temp = 'Z' . $result;
} else {
$temp = chr(64 + $mod) . $result;
}
$result = $temp;
}
return $result;
}
php : excel获取字母表头
最新推荐文章于 2021-12-22 15:40:31 发布