数据库导出xls格式表

 public function orderDaochu()
    {
        $where=[];
        $post = $this->request->post();　　　　　//年月日判断　　
        if(isset($post['create_time']) and !empty($post['create_time'])) {
            $min_time = strtotime($post['create_time']);
            $max_time = $min_time + 24 * 60 * 60;
            $where['create_time'] = [['>=',$min_time],[',$max_time]];
        }
        $model = new userModel();
        $address = $model->where($where)->select();
        vendor("PHPExcel.PHPExcel.PHPExcel");//引入插件
        $objPHPExcel = new \PHPExcel();
        // 设置sheet
        $objPHPExcel->setActiveSheetIndex(0);
        // 设置列的宽度
        $objPHPExcel->getActiveSheet()->getColumnDimension('E')->setWidth(30);
        $objPHPExcel->getActiveSheet()->getColumnDimension('H')->setWidth(20);
        $objPHPExcel->getActiveSheet()->getColumnDimension('I')->setWidth(30);
        $objPHPExcel->getActiveSheet()->getColumnDimension('K')->setWidth(30);
        $objPHPExcel->getActiveSheet()->getColumnDimension('J')->setWidth(30);
        $objPHPExcel->getActiveSheet()->getColumnDimension('F')->setWidth(30);
        $objPHPExcel->getActiveSheet()->getColumnDimension('D')->setWidth(20);
        $objPHPExcel->getActiveSheet()->getColumnDimension('G')->setWidth(20);
        // 设置表头
        $objPHPExcel->getActiveSheet()->SetCellValue('A1', 'ID');
        $objPHPExcel->getActiveSheet()->SetCellValue('B1', '昵称');
        $objPHPExcel->getActiveSheet()->SetCellValue('C1', '用户头像');
        $objPHPExcel->getActiveSheet()->SetCellValue('D1', '性别');
        $objPHPExcel->getActiveSheet()->SetCellValue('E1', '年龄');
        $objPHPExcel->getActiveSheet()->SetCellValue('F1', '积分');
        $objPHPExcel->getActiveSheet()->SetCellValue('G1', '添加用户时间');
        $objPHPExcel->getActiveSheet()->SetCellValue('H1', '手机号');
        $objPHPExcel->getActiveSheet()->SetCellValue('I1', '用户名');
        $objPHPExcel->getActiveSheet()->SetCellValue('J1', '收货人手机号');
        $objPHPExcel->getActiveSheet()->SetCellValue('K1', '地址');
        $objPHPExcel->getActiveSheet()->SetCellValue('L1', '生日');
        //存取数据
        $num = 2;
        foreach ($address as $k => $v) {　　　　　　　　//你的数据库内容
            $objPHPExcel->getActiveSheet()->SetCellValue('A' . $num, $v['id']);
            $objPHPExcel->getActiveSheet()->SetCellValue('B' . $num, $v['nickname']);
            $objPHPExcel->getActiveSheet()->SetCellValue('C' . $num, $v['thumb']);
            $objPHPExcel->getActiveSheet()->SetCellValue('D' . $num, $v['sex']);
            $objPHPExcel->getActiveSheet()->SetCellValue('E' . $num, $v['age']);
            $objPHPExcel->getActiveSheet()->SetCellValue('F' . $num, $v['integral']);
            $objPHPExcel->getActiveSheet()->SetCellValue('G' . $num, $v['create_time']);
            $objPHPExcel->getActiveSheet()->SetCellValue('H' . $num, $v['phone']);
            $objPHPExcel->getActiveSheet()->SetCellValue('I' . $num, $v['shou_name']);
            $objPHPExcel->getActiveSheet()->SetCellValue('J' . $num, $v['shou_phone']);
            $objPHPExcel->getActiveSheet()->SetCellValue('K' . $num, $v['address']);
            $objPHPExcel->getActiveSheet()->SetCellValue('L' . $num, $v['user_time']);

            $num++;
        }
        // 文件名称
        $fileName = "用户" . date('Y-m-d', time()) . rand(1, 1000);
        $xlsName = iconv('utf-8', 'gb2312', $fileName);
        // 设置工作表名
        $objPHPExcel->getActiveSheet()->setTitle('sheet');
        //下载 excel5与excel2007
        $objWriter = new \PHPExcel_Writer_Excel5($objPHPExcel);
        ob_end_clean();     // 清除缓冲区,避免乱码
        header("Pragma: public");
        header("Expires: 0");
        header("Cache-Control:must-revalidate,post-check=0,pre-check=0");
        header("Content-Type:application/force-download");
        header("Content-Type:application/vnd.ms-execl;charset=UTF-8");
        header("Content-Type:application/octet-stream");
        header("Content-Type:application/download");
        header("Content-Disposition:attachment;filename=" . $xlsName . ".xls");
        header("Content-Transfer-Encoding:binary");
        $objWriter->save("php://output");
        return json(['msg'=>'导出成功']);
    }