php生成excel列序号代码实例

复制代码 代码如下:
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>";   
  }
 }