php导出excel

/** Include PHPExcel */
require_once './utils/excel/PHPExcel.php';
require_once './utils/excel/PHPExcel/IOFactory.php';  
require_once './utils/excel/PHPExcel/Writer/Excel5.php'; 


//设置参数 
$resultPHPExcel->getActiveSheet()->setCellValue('A1', '用户id');
$resultPHPExcel->getActiveSheet()->setCellValue('B1', '用户名');
$resultPHPExcel->getActiveSheet()->setCellValue('C1', '订单号');
$resultPHPExcel->getActiveSheet()->setCellValue('D1', '交易号');
$resultPHPExcel->getActiveSheet()->setCellValue('E1', '姓名');
$resultPHPExcel->getActiveSheet()->setCellValue('F1', '性别');
$resultPHPExcel->getActiveSheet()->setCellValue('G1', '电话');
$resultPHPExcel->getActiveSheet()->setCellValue('H1', '省份');
$resultPHPExcel->getActiveSheet()->setCellValue('I1', '城市');
$resultPHPExcel->getActiveSheet()->setCellValue('J1', '经销商');
$resultPHPExcel->getActiveSheet()->setCellValue('K1', '验证码');
$resultPHPExcel->getActiveSheet()->setCellValue('L1', '车型');
$resultPHPExcel->getActiveSheet()->setCellValue('M1', '付款状态');
$resultPHPExcel->getActiveSheet()->setCellValue('N1', '是否上传发票');
$resultPHPExcel->getActiveSheet()->setCellValue('O1', '审核状态');
$resultPHPExcel->getActiveSheet()->setCellValue('P1', '地址');
$resultPHPExcel->getActiveSheet()->setCellValue('Q1', '发票');
$resultPHPExcel->getActiveSheet()->setCellValue('R1', '上传发票时间');
$resultPHPExcel->getActiveSheet()->setCellValue('S1', '来源');
$resultPHPExcel->getActiveSheet()->setCellValue('T1', '是否订单');
$resultPHPExcel->getActiveSheet()->setCellValue('U1', '支付方式');
$resultPHPExcel->getActiveSheet()->setCellValue('V1', '注册时间');
$resultPHPExcel->getActiveSheet()->setCellValue('W1', 'ip');

$i = 2; 
foreach($data as $item){
$resultPHPExcel->getActiveSheet()->setCellValue('A' . $i, $item['xcaruid']);
$resultPHPExcel->getActiveSheet()->setCellValue('B' . $i, $item['xcaruser']);
$resultPHPExcel->getActiveSheet()->setCellValue('C' . $i, ' '.$item['xcar_order_sn']);
$resultPHPExcel->getActiveSheet()->setCellValue('D' . $i, $item['xcar_trade_no']);
$resultPHPExcel->getActiveSheet()->setCellValue('E' . $i, $item['name']);
$resultPHPExcel->getActiveSheet()->setCellValue('F' . $i, $item['gender']);
$resultPHPExcel->getActiveSheet()->setCellValue('G' . $i, ' '.$item['mobile']);
$resultPHPExcel->getActiveSheet()->setCellValue('H' . $i, $item['province']);
$resultPHPExcel->getActiveSheet()->setCellValue('I' . $i, $item['city']);
$resultPHPExcel->getActiveSheet()->setCellValue('J' . $i, $item['dealer']);
$resultPHPExcel->getActiveSheet()->setCellValue('K' . $i, $item['auth_code']);
$resultPHPExcel->getActiveSheet()->setCellValue('L' . $i, $item['car_type']);
$resultPHPExcel->getActiveSheet()->setCellValue('M' . $i, $item['pay']);
$resultPHPExcel->getActiveSheet()->setCellValue('N' . $i, $item['is_upload']);
$resultPHPExcel->getActiveSheet()->setCellValue('O' . $i, $item['verify']);
$resultPHPExcel->getActiveSheet()->setCellValue('P' . $i, $item['addr']);
$resultPHPExcel->getActiveSheet()->setCellValue('Q' . $i, $item['invoice']);
$resultPHPExcel->getActiveSheet()->setCellValue('R' . $i, $item['upload_time']);
$resultPHPExcel->getActiveSheet()->setCellValue('S' . $i, $item['source']);
$resultPHPExcel->getActiveSheet()->setCellValue('T' . $i, $item['is_order']);
$resultPHPExcel->getActiveSheet()->setCellValue('U' . $i, $item['pay_type']);
$resultPHPExcel->getActiveSheet()->setCellValue('V' . $i, $item['instime']);
$resultPHPExcel->getActiveSheet()->setCellValue('W' . $i, $item['ip']);
$i ++;
}


//设置导出文件名 
$outputFileName = 'total.xls'; 
$xlsWriter = new PHPExcel_Writer_Excel5($resultPHPExcel); 
//ob_start(); ob_flush(); 
header("Content-Type: application/force-download"); 
header("Content-Type: application/octet-stream"); 
header("Content-Type: application/download"); 
header('Content-Disposition:inline;filename="'.$outputFileName.'"'); 
header("Content-Transfer-Encoding: binary"); 
header("Expires: Mon, 26 Jul 1997 05:00:00 GMT"); 
header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT"); 
header("Cache-Control: must-revalidate, post-check=0, pre-check=0"); 
header("Pragma: no-cache"); 
$xlsWriter->save( "php://output" );