PHP는 Excel에서 열 번호를 생성합니다.

/**
* 用php代码生成excel或csv文件中的序列号
*/
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 ."";
  } // bbs.it-home.org
 }