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>"; } }