php生成excel列序号代码实例
发布时间:2016-12-29 来源:查字典编辑
摘要:复制代码代码如下:publicfunctionloop(){$loop=0;$charnum=65;for(;$loop0?chr($cha...
复制代码 代码如下:
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 ."<br>";
}
}