php 生成 excel

来源：互联网发布：信鸽软件怎么样编辑：程序博客网时间：2024/06/07 21:06
/** * 导出当前的提现记录 ci框架  部分要更具自己情况修改 * @return [ecexl] [生成excel文档] */function excelapply(){$keysid = $_GET['keysid'];        $memberid = $this->userinfo['id'];        $date = array();        $sql="select * from wx_cash_withdrawal where memberid={$memberid} and id in ({$keysid})";        $sql .=" order by id desc";        $query = $this->db->query($sql);        $res = $query->result_array();        require_once('./application/libraries/Phpexcel.php');        require_once './application/libraries/PHPExcel/Writer/Excel5.php';        // Create new PHPExcel object        $objPHPExcel = new PHPExcel();        $objProps = $objPHPExcel->getProperties();        $objProps->setCreator("tax");        $objProps->setTitle("提现记录");        $objPHPExcel->setActiveSheetIndex(0);        $sheet = $objPHPExcel->getActiveSheet();        $objPHPExcel->getActiveSheet()->getStyle('J')->getAlignment()->setWrapText(true);        $objPHPExcel->getActiveSheet()->getStyle('K')->getAlignment()->setWrapText(true);        $objPHPExcel->getActiveSheet()->getStyle('L')->getAlignment()->setWrapText(true);        $objPHPExcel->getActiveSheet()->getStyle('M')->getAlignment()->setWrapText(true);// 標題        $sheet->setTitle('提现记录');        $sheet->setCellValue('A1', '序号');        $sheet->setCellValue('B1', '开户人姓名');        $sheet->setCellValue('C1', '金额(元)');        $sheet->setCellValue('D1', '开户行/支行');        $sheet->setCellValue('E1', '申请时间');        $sheet->setCellValue('F1', '手机号');        $sheet->setCellValue('G1', '状态');        /*$sheet->getStyle('A')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);        $sheet->getStyle('B')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);*/        $sheet->getColumnDimension('A')->setWidth(5);        $sheet->getColumnDimension('B')->setWidth(10);        $sheet->getColumnDimension('C')->setWidth(10);        $sheet->getColumnDimension('D')->setWidth(20);        $sheet->getColumnDimension('E')->setWidth(20);        $sheet->getColumnDimension('F')->setWidth(20);        $sheet->getColumnDimension('G')->setWidth(20);        $i = 2;        foreach ($res as $k=>$v) {        switch ($v['bankname']) {                case '1':                    $bank='中国银行';                    break;                case '2':                    $bank='中国工商银行';                    break;                case '3':                    $bank='中国建设银行';                    break;                case '4':                    $bank='中国农业银行';                    break;                case '5':                    $bank='中国交通银行';                    break;                case '6':                    $bank='中国邮政储蓄';                    break;                case '7':                    $bank='支付宝';                    break;                case '8':                    $bank='财付通';                    break;                default:                    $bank='空';                    break;            }            $sheet->setCellValue('A' . $i, $k+1);            $sheet->setCellValue('B' . $i, $v['name']);            $sheet->setCellValue('C' . $i, $v['money']);            $sheet->setCellValue('D' . $i, $bank);            $sheet->setCellValue('E' . $i, date('Y-m-d H:i',$v['creattime']));            $sheet->setCellValue('F' . $i, ' '.$v['mobile'].' ');            $sheet->setCellValue('G' . $i, $v['status']==1?'待提现':'已提现');            $i++;        }        $objWriter = new PHPExcel_Writer_Excel5($objPHPExcel);       // 輸出 Excel        header('Content-Type: application/vnd.ms-excel');        header('Content-Disposition: attachment;filename="提现记录'.date('Y-m-d H-i-s',time()).'.xls"');        header('Cache-Control: max-age=0');        //$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');        $objWriter->save('php://output');    }
0 0