当前位置:Gxlcms > PHP教程 > php生成excel列序号代码实例_PHP

php生成excel列序号代码实例_PHP

时间:2021-07-01 10:21:17 帮助过:30人阅读

代码如下:
public function loop(){
$loop = 0;
$charnum = 65;

for(; $loop < 150; $loop++){
$quotient = intval($loop / 26);
$remainder = $loop % 26;

$f = $quotient>0? chr($charnum+$quotient-1) : '';
$s = $remainder>=0? chr($charnum+$remainder) : '';

echo $loop .' | '. $quotient .' | '. $remainder .' | '. $f . $s ."
";


}
}

人气教程排行