导出excel表格

//引入phpecxcel的文件
require_once ‘…/PHPExcel/Classes/PHPExcel.php’;
require_once ‘…/PHPExcel/Classes/PHPExcel/IOFactory.php’;
$objPHPExcel = new \PHPExcel();//实例化

$objPHPExcel->getProperties()->setCreator("Maarten Balliauw")
    ->setLastModifiedBy("Maarten Balliauw")
    ->setTitle("Document")
    ->setSubject("Document")
    ->setDescription("Document")
    ->setKeywords("office")
    ->setCategory("result file");
//查询出来列表数据
$objPHPExcel->setActiveSheetIndex(0)
    ->setCellValue('A1', '序号')
    ->setCellValue('B1', '产品名称')
    ->setCellValue('C1', '申请用户')
    ->setCellValue('D1', '客户名称')
    ->setCellValue('E1', '合同金额')
    ->setCellValue('F1', '费率')
    ->setCellValue('G1', '实际费率')
    ->setCellValue('H1', '总期数');
$arr=product_zend_list();
$data=$arr['arr'];
for($i=2;$i <= count($data)+1;$i++){
    $objPHPExcel->setActiveSheetIndex(0)
        ->setCellValue('A'.$i, $data[$i-2]['id'])
        ->setCellValue('B'.$i, $data[$i-2]['name'])
        ->setCellValue('C'.$i, $data[$i-2]['user_name'])
        ->setCellValue('D'.$i, $data[$i-2]['pcvalue'])
        ->setCellValue('E'.$i, $data[$i-2]['open_amount'])
        ->setCellValue('F'.$i, $data[$i-2]['rate'])
        ->setCellValue('G'.$i, $data[$i-2]['real_rate'])
        ->setCellValue('H'.$i, $data[$i-2]['periods']);
}

ob_end_clean();
$outputFileName ="贷后列表".date('Y_m_d_H_i_s');
ini_set("memory_limit","500M");
header("Content-type: application/vnd.ms-excel; charset=utf-8");
header('Content-Disposition: attachment;filename=""'.$outputFileName.'.xls"');
header('Cache-Control: max-age=0');
$objWriter = \PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
//$objWriter->save('./excel/'.$outputFileName.'.xlsx');
$objWriter->save('php://output');
exit;