导航

php 导出Excel功能（放在公共函数里面即可使用）-----第一篇

Posted on 2018-03-02 11:21  小葱大豆腐  阅读(335)  评论(0)    收藏  举报 

/*限制5000
 * $data 数据二维数组
 * $title 表格标题 如：$title=['产品id','产品姓名','产品密码','产品图片'];
 * $savefile  表格名称 如： $savefile='产品表';
 * */
function exportExcel($data = array(), $title = array(), $savefile = null)
{
    header("Content-type: text/html; charset=UTF-8");
    header("Content-type:application/vnd.ms-excel");
    header("Content-Disposition: attachment;filename=" . $savefile . ".xls");
    header("Content-Type: application/vnd.ms-excel; charset=UTF-8");
    $html = "<HTML>";
    $html .= "<HEAD>";
    $html .= "<META http-equiv=Content-Type content=\"text/html; charset=utf-8\">";
    $html .= "</HEAD>";
    $html .= "<BODY>";
    $html .= "<TABLE BORDER=1>";
    //colspan = "4"表示有多少列，根据需要而定。
    $html .= '<tr><td style="width: 500px;font-size: 20px;" colspan = "4" align="center" valign="middle">' . $savefile . '</td></tr>';
    $html .= '<tr>';
    foreach ($title as $v) {
        $html .= "<td style='width:150px'>{$v}</td>";
    }
    $html .= '</tr>';
    foreach ((array)$data as $r => $value) {
        $html .= '<tr>';
        foreach ((array)$value as $c => $v) {
            if (strripos($v, '.') > 0) {
                $html .= "<td style='text-align:right;' >" . $v . "</td>";
            } else {
                $html .= "<td style='vnd.ms-excel.numberformat:@' >" . " " . $v . "</td>";
            }
        }
        $html .= '</tr>';
    }
    $html .= "</TABLE>";
    $html .= "</BODY>";
    $html .= "</HTML>";
    echo $html;
    exit;

}