Home  >  Article  >  php教程  >  php生成excel列序号代码实例

php生成excel列序号代码实例

WBOY
WBOYOriginal
2016-06-06 20:26:02983browse

php生成excel列序号的方法,大家参考使用吧

复制代码 代码如下:


public function loop(){
  $loop = 0;
  $charnum = 65;

  for(; $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 ."
";

   
  }
 }

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn