/** 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" );
php导出excel
最新推荐文章于 2022-04-18 14:23:46 发布