导出excel时，数字过长怎么解决

导出excel时，数字过长怎么解决

主要是使用 setCellValueExplicit()方法：
        $objPHPExcel->getActiveSheet()->setCellValueExplicit($colum . $i, $item);

/**
 * 支持过长数字单元格
 */
function dataToExcel2($header, $data, $filename = 'abc')
{
    require(EXTEND_PATH . 'excel/PHPExcel.php');
    $objPHPExcel = new PHPExcel();
    // Rename worksheet
    $objPHPExcel->getActiveSheet()->setTitle('Phpmarker-' . date('Y-m-d'));
    // Set active sheet index to the first sheet, so Excel opens this as the first sheet
    $objPHPExcel->setActiveSheetIndex(0);
    //设置header
    if (!is_array($header)) {
        return false;
    }
    $ini = 65;//A的acsii码
    foreach ($header as $value) {
        $colum = \PHPExcel_Cell::stringFromColumnIndex($ini - 65);
        $objPHPExcel->getActiveSheet()->setCellValue($colum . '1', $value);
        $ini++;
    }
    if (!is_array($data)) {
        return false;
    }
    $i = 2;

    foreach ($data as $val) {
        $ini = 65;
        foreach ($val as $item) {
            $colum = \PHPExcel_Cell::stringFromColumnIndex($ini - 65);
            $objPHPExcel->getActiveSheet()->setCellValueExplicit($colum . $i, $item);
            $ini++;
        }
        ++$i;
    }

    // 输出Excel表格到浏览器下载
    header('Content-Type: application/vnd.ms-excel');
    header('Content-Disposition: attachment;filename="' . $filename . '.xls"');
    header('Cache-Control: max-age=0');
    // If you're serving to IE 9, then the following may be needed
    header('Cache-Control: max-age=1');

    // If you're serving to IE over SSL, then the following may be needed
    header('Expires: Mon, 26 Jul 1997 05:00:00 GMT'); // Date in the past
    header('Last-Modified: ' . gmdate('D, d M Y H:i:s') . ' GMT'); // always modified
    header('Cache-Control: cache, must-revalidate'); // HTTP/1.1
    header('Pragma: public'); // HTTP/1.0

    $objWriter = new PHPExcel_Writer_Excel5($objPHPExcel);
    $objWriter->save('php://output');
}