<h1>PHPExcle获取字母列算法</h1> * * * * * PHPExcle获取字母列算法 <span style="color:#B03060;font-size:22px;font-weight:800">代码如下:</span> ~~~ function getZ($z){ $header_arr = array('A','B','C','D','E','F','G','H','I','J','K','L','M', 'N','O','P','Q','R','S','T','U','V','W','X','Y','Z'); $xiabiao = ($z%count($header_arr)!=0)?intval($z/count($header_arr))-1:intval($z/count($header_arr))-2; // $xiabiao = intval($z/count($header_arr))-2; $lie = ($z%count($header_arr)!=0)?($z%count($header_arr)-1):count($header_arr)-1; $xiabiao_str = ''; if($header_arr >= 0){ $xiabiao_str = $header_arr[$xiabiao]; } return $xiabiao_str.$header_arr[$lie]; } ~~~