phpExcel导出表格

来源：互联网发布：中国照相馆知乎编辑：程序博客网时间：2024/05/21 07:49
数据统计需要,导出数据表格,本人使用的PHPExcel扩展
<?phprequire_once "PHPExcel.php";require_once 'PHPExcel/IOFactory.php';require_once 'PHPExcel/Writer/Excel5.php';public function actionGetExport() {$resultPHPExcel = new PHPExcel();$resultPHPExcel->getActiveSheet()->setCellValue('A1', "要导出的表格的名称");$resultPHPExcel->getActiveSheet()->mergeCells('A1:H1');//设置参数$resultPHPExcel->getActiveSheet()->setCellValue('A2', '名称');$resultPHPExcel->getActiveSheet()->setCellValue('B2', '下单笔数');$resultPHPExcel->getActiveSheet()->setCellValue('C2', '成功笔数');$resultPHPExcel->getActiveSheet()->setCellValue('D2', '成功总金额（元）');$resultPHPExcel->getActiveSheet()->setCellValue('E2', '充值成功率');$resultPHPExcel->getActiveSheet()->setCellValue('F2', '下单笔数占比');$resultPHPExcel->getActiveSheet()->setCellValue('G2', '充值金额占比');$resultPHPExcel->getActiveSheet()->setCellValue('H2', '平均充值金额（元）');$data  = '从库中查询的数据';$i = 3;foreach($data as &$item) {$resultPHPExcel->getActiveSheet()->setCellValue('A' . $i, $payments[$item['payment_id']]);$resultPHPExcel->getActiveSheet()->setCellValue('B' . $i, $item['count']);$resultPHPExcel->getActiveSheet()->setCellValue('C' . $i, $item['count_succeed']);$resultPHPExcel->getActiveSheet()->setCellValue('D' . $i, $item['amount']);$resultPHPExcel->getActiveSheet()->setCellValue('E' . $i, (number_format($item['count_succeed'] / $item['count'], 4, '.', '') * 100) . '%');$resultPHPExcel->getActiveSheet()->setCellValue('F' . $i, (number_format($item['count'] / $totalCount, 4, '.', '') * 100) . '%');$resultPHPExcel->getActiveSheet()->setCellValue('G' . $i, (number_format($item['amount'] / $totalMoney, 4, '.', '') * 100) . '%');        $resultPHPExcel->getActiveSheet()->setCellValue('H' . $i, 0);$i ++;}$outputFileName = 'total_'.date('Y/m/d H:i:s').'.xls';            $xlsWriter = new PHPExcel_Writer_Excel5($resultPHPExcel);            header('Content-type:application/vnd.ms-excel');            header('Content-Disposition:inline;filename="'.$outputFileName.'"');            $xlsWriter->save( "php://output" );}?>
0 0