excel的列生成算法

echo '<pre>';

$i = 1;

while($i < 703){

    $char1 = floor($i / 26);

    $char2 = $i % 26;

    if($i % 26 == 0)$char1--;

    if($i > 1 && $i % 26 == 1)     echo '<br/>';

    if($char2 == 0) $char2 = 26;

    if($i <= 26){

        echo ' '.chr(64 + $char2). '&emsp;';

    }else{

        echo chr(64 + $char1) . chr(64 + $char2) . '&emsp;';

    }

    $i++;

}

echo '</pre>';

/**

 * 根据当前列号,返回列字符

 * @param int $i

 * @return string

 */

function get_excel_row_name($i){

    $char1 = floor($i / 26);

    $char2 = $i % 26;

    if($i % 26 == 0) $char1--;

    if($char2 == 0) $char2 = 26;

    if($i <= 26){

        return chr(64 + $char2);

    }else{

        return chr(64 + $char1) . chr(64 + $char2);

    }

}