PHP快速导出Table数据（5.5版本）

来源：互联网发布：编程是什么专业编辑：程序博客网时间：2024/06/05 18:21

//先获取某个数据          $date = input();          $id = @$date['data'];         $dataResult=Db::table('demo')             ->where('id','in',$id)             ->select();//        $dataResult = input('data');//        $dataResult = json_decode($dataResult,true);//        dump($dataResult);die;        $headTitle = "XX数据";        $title = date("Y-m-d")."-"."XX数据导出数据";//        $headtitle = "<tr style='height:50px;border-style:none;><td border=\"0\" style='height:60px;width:270px;font-size:22px;' colspan='11'>{$headTitle}</th></tr>";        $headtitle = "<tr style='height:50px;border-style: none;><td border=\"0\" style='height: 60px;width:270px;font-size=22px;' colspan='11'>{$headTitle}</th></tr>";        $titlename="<tr>           <td>编号</td>           <td>XX标题</td>           <td>姓名</td>           <td>年龄</td>           <td>性别</td>           <td>XX号</td>           <td>XX室</td>           <td>XX区</td>           <td>XX志</td>           <td>XX时间</td>           <td>XX操作</td>           <td>XX备注</td>           <td>XX修改</td>           <td>XX时间</td>           <td>XX类型</td>           <td>XX标识</td>       </tr>";        $filename = $title.".xls";//        dump($title);        $this->excelData($dataResult,$titlename,$headtitle,$filename);

  public function excelData($datas,$titlename,$title,$filename)    {        $str = "<html xmlns:o=\"urn:schemas-microsoft-com:office:office\"\r\nxmlns:x=\"urn:schemas-microsoft-com:office:excel\"\r\nxmlns=\"http://www.w3.org/TR/REC-html40 \">\r\n<head>\r\n<meta http-equiv=Content-Type content=\"text/               html;charset=utf-8\">\r\n</head>\r\n<body>";        $str .="<table border=1>".$titlename;        $str .= '';        foreach ($datas  as $key=> $rt )        {            $str .= "<tr>";            $str .= "<td>{$rt['id']}</td>";            $str .= "<td>{$rt['title']}</td>";            $str .= "<td>{$rt['user']}</td>";            $str .= "<td>{$rt['age']}</td>";            $str .= "<td>{$rt['sex']}</td>";            $str .= "<td>{$rt['num']}</td>";            $str .= "<td>{$rt['department']}</td>";            $str .= "<td>{$rt['lesion']}</td>";            $str .= "<td>{$rt['file']}</td>";            $str .= "<td>{$rt['time']}</td>";            $str .= "<td>{$rt['status']}</td>";            $str .= "<td>{$rt['content']}</td>";            $str .= "<td>{$rt['modify']}</td>";            $str .= "<td>{$rt['chtime']}</td>";            $str .= "<td>{$rt['insurance']}</td>";            $str .= "<td>{$rt['modify']}</td>";            $str .= "</tr>\n";        }        $str .= "</table></body></html>";        header( "Content-type:application/vnd.ms-excel;name='excel'");        header( "Content-type: application/octet-stream" );        header( "Content-Disposition: attachment; filename=".$filename );        header( "Cache-Control: must-revalidate, post-check=0, pre-check=0" );        header( "Pragma: no-cache" );        header( "Expires: 0" );        exit( $str );    }

这种方法可快速导出数据不需要加载第三方phpExcel类库，线下测试环境php5.5可以如果线上环境是php7.0建议使用phpexcel类库1.81,php7.0有点问题不太建议我这个写法。

阅读全文

1 0