php generates excel column ordinal code instances

  • 2020-11-30 08:11:10
  • OfStack


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

   
  }
 }

Related articles: