PHP Excel导出类库-优快云博客

本文链接：https://blog.youkuaiyun.com/l_forever/article/details/78388917

本文介绍了一个使用PHP实现的Excel导出类库，通过简单的构造函数和下载方法即可将数据库查询结果转换为Excel文件并提供下载。该类库支持设置文件名，并能够自动生成包含查询结果的表格。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

report.php

<?php
/**
 * @copyright (c) 2014 aircheng
 * @file report.php
 * @brief 导出excel类库
 * @author LiuQi
 * @date 2017/03/30 16:36:43
 * @version 1.0.0
 */
class report
{
    //文件名
    private $fileName = 'user';

    //构造函数
    public function __construct($fileName = '')
    {
        $this->setFileName($fileName);
    }

    //设置要导出的文件名
    public function setFileName($fileName)
    {
        $this->fileName = $fileName;
    }

    //开始下载
    public function toDownload($strTable)
    {
        header("Content-type: application/vnd.ms-excel");
        header("Content-Type: application/force-download");
        header("Content-Disposition: attachment ; filename=".$this->fileName."_".date('Y-m-d').".xls");
        header('Expires:0');
        header('Pragma:public');
        echo '<html><meta http-equiv="Content-Type" content="text/html; charset=utf-8" />'.$strTable.'</html>';
    }
}

demo.php

<?php 
header('content-type:text/html;charset=utf-8');
require "report.php";
$ticketFile = "文件名";
// $excelStr = "表格中的内容";
$excelStr = '<table border="1px"><tr><th>卡号</th><th>网址</th><th>分类</th></tr>';
try{
    $pdo = new PDO("mysql:host=127.0.0.1;dbname=collect","root","root");
}catch(PDOException $e ){
    echo $e->getMessage();
}
$pdo->query("set names utf8");
$sql = "SELECT * from day0310 limit 10";
$list = $pdo->query($sql);
$list->setFetchMode(PDO::FETCH_ASSOC);
$re = $list->fetchAll();

foreach ($re as $key => $value) {
    $excelStr.='<tr align="center">';
    $excelStr.='<td>'.$value['id'].'</td>';
    $excelStr.='<td>'.$value['link'].'</td>';
    $excelStr.='<td>'.$value['title'].'</td>';
    $excelStr.='</tr>';
}
$reportObj = new report($ticketFile);
$reportObj->toDownload($excelStr);

PHP导出EXCEL

report.php

demo.php