用phpExcel进行导出

最新推荐文章于 2024-03-27 09:15:31 发布

shan~~

最新推荐文章于 2024-03-27 09:15:31 发布

阅读量228

点赞数

文章标签： excel php

本文链接：https://blog.csdn.net/qq_36189997/article/details/131127553

版权

require_once("plugins/phpexcel/phpexcel.class.php");
        $where = "";
        if (I('get.startTime') && I('get.endTime')) {
            $startTime = I('get.startTime');
            $endTime = I('get.endTime');
            $where['add_time']= ['between',[$startTime,$endTime]];
        }
        else if (I('get.startTime')) {
            $startTime = I('get.startTime');
            $where['add_time']= ['EGT',$startTime];
        }else if(I('get.endTime')){
            $endTime = I('get.endTime');
            $where['add_time']= ['ELT',$endTime];
        }
        $ApplyInfo = M("app");
        $data = $ApplyInfo->where($where)->select();
      
        $excel = new \PHPExcel();
        $excel ->getProperties()
            ->setTitle('应用')
            ->setCreator('jing')
            ->setSubject('申请');
        $sheet = $excel->setActiveSheetIndex(0);
        $sheet->setCellValue('A1', '序号')
        ->setCellValue('B1', '应用名字')
        ->setCellValue('C1', '应用版本号')
        ->setCellValue('D1', '下载链接')
        ->setCellValue('E1', '型号')
        ->setCellValue('F1', '系统')
        ->setCellValue('G1', '提交人')
        ->setCellValue('H1', '提交人邮箱')
        ->setCellValue('I1', '提交人手机号')
        ->setCellValue('J1', '备注')
        ->setCellValue('K1', '时间');  
      
        $num = 2;
        foreach($data as $k => $v){
            $sheet->setCellValue('A'.$num, $num-1)
                    ->setCellValue('B'.$num, ' '.$v['apply_name'])
                    ->setCellValue('C'.$num, ' '.$v['version'])
                    ->setCellValue('D'.$num, ' '.$v['download_link'])
                    ->setCellValue('E'.$num, ' '.$v['model'])
                    ->setCellValue('F'.$num, $v['os'])
                    ->setCellValue('G'.$num, $v['commit_name'])
                    ->setCellValue('H'.$num, $v['commit_email'])
                    ->setCellValue('I'.$num, $v['commit_phone'])
                    ->setCellValue('J'.$num, $v['remarks'])
                    ->setCellValue('K'.$num, $v['add_time']);
            $num++;
        }
        $excel->setActiveSheetIndex(0);
        $filename = iconv('utf-8','gbk','应用申请.xls');
        header('Content-Type: application/vnd.ms-excel');
        header('Content-Disposition: attachment;filename="'.$filename.'"');
        header('Cache-Control: max-age=0');
        $objWriter = \PHPExcel_IOFactory::createWriter($excel, 'Excel5');
        $objWriter->save('php://output');
        exit();
        die;