php生成xls表格

下载扩展包

PHPExcel

https://github.com/PHPOffice/PHPExcel/tree/1.8/Classes

function IntToChr($index, $start = 65)
{
    $str = '';
    if (floor($index / 26) > 0) {
        $str .= IntToChr(floor($index / 26) - 1);
    }
    return $str . chr($index % 26 + $start);
}

objPHPExcel=new phpexcel();
foreach ($header as $key => $value) {
    $total = Helper::IntToChr($key);
    $objPHPExcel->setActiveSheetIndex(0)
        ->setCellValue($total . '1', $value);
}
foreach ($data as $key => $value) {
    $num = $key + 2;
    $data_key = array_keys($value);
    foreach ($data_key as $ks => $vs) {
        $total = Helper::IntToChr($ks);
        $objPHPExcel->setActiveSheetIndex(0)
            ->setCellValue($total . $num, $value[$vs]);
    }
}
ob_end_clean();//清除缓冲区,避免乱码
$fileName = date('Ymd');
header('pragma:public');
header('Content-type:application/vnd.ms-excel;charset=utf-8;name="' . $fileName . '.xls"');
header("Content-Disposition:attachment;filename=$fileName.xls");
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
$objWriter->save('php://output');