php 下载数据到excel表格

最新推荐文章于 2019-08-15 09:16:42 发布

Gy__My

最新推荐文章于 2019-08-15 09:16:42 发布

阅读量546

点赞数

文章标签： php cakePHP3 excel

本文链接：https://blog.csdn.net/Gy__My/article/details/51637209

版权

不啰嗦了，直接上代码：

<?php

public function getxls($theDay){
    //从数据库去除数据(用的是cakePHP)
    $act = TableRegistry::get('test');
    $res = $act->getData($theDay);
    //格式化
    foreach($res as $value){
        $con = array($value['username'],$value['shipdate'],$value['address'],$value['userphone'],$value['solution']);
        $data[] = $con;
    }

    /*下载表格*/
    if($data){
        $output = "<HTML>";
        $output .= "<HEAD>";
        $output .= '<META http-equiv=Content-Type content="text/html; charset=utf8">';
        $output .= "</HEAD>";
        $output .= "<BODY>";
        $output .= "<TABLE BORDER=1 width=100%>";
        $output .= "<tr><td width=5%>ID</td><td width=6%>姓名</td><td width=8%>再配送日期</td><td width=12%>地址</td><td width=8%>电话</td><td width=13%>解决方案</td></tr>";
        $i = 1;
        if($data){
            foreach ($data as $kvalue) {

                $output .= "<tr><td>".$i++."</td><td>{$kvalue['0']}</td><td>{$kvalue['1']}</td><td>{$kvalue['2']}</td><td>{$kvalue['3']}</td><td>{$kvalue['4']}</td>";
            }
        }


        $output .= "<tr><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td></tr>";
        $output .= "</TABLE>";
        $output .= "</BODY>";
        $output .= "</HTML>";
        $outname = '导出'.$theDay.'-售后表';
        header("Content-type:application/msexcel");                                         //用php的header函数来声明excel
        header("Content-disposition: attachment; filename=".$outname.".xls");         //用php的header函数来声明excel的格式
        header("Cache-control: private");
        header("Pragma: private");
        print($output);         //下载excel文件到客户端
        exit;
    }else{
        echo 'Not fand';
        exit;
    }
}

Gy__My

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
打赏
0
评论
php 下载数据到excel表格

不啰嗦了，直接上代码：<?phppublic function getxls($theDay){ //从数据库去除数据(用的是cakePHP) $act = TableRegistry::get('test'); $res = $act->getData($theDay); //格式化 foreach($res as $value){
复制链接

扫一扫