• PHP导出word,CVS,PDF


    本文转自 http://www.cnblogs.com/thinksasa/p/3504153.html

    WORD:

    <?php
    header("Cache-Control: no-cache, must-revalidate");
    header("Pragma: no-cache");
    //有了这些,可以把带html标签的html源码导入到word里,并且可以保持html的样式。
    /* 
    <STYLE>
    BR.page { page-break-after: always }
    </STYLE>
    在<head>部分加这个是为了实现打印的时候分页
     */
    $wordStr = '<html xmlns:o="urn:schemas-microsoft-com:office:office"
    xmlns:w="urn:schemas-microsoft-com:office:word"
    xmlns="http://www.w3.org/TR/REC-html40">
    <head>
    <STYLE>
    BR.page { page-break-after: always }
    </STYLE>
    </head><body>';
    
        $wordStr = "<b>hello</b><p>this is html code</p>";
    
        $wordStr .= '</body></html>';
        //防止导出乱码
        $file = iconv("utf-8", "GBK", $filename);
    
        header("Content-Type: application/doc");
        header("Content-Disposition: attachment; filename=" . $file . ".doc");
        echo $wordStr;
    ?>
    

      

    CVS:

    <?php
    header("Content-Disposition: attachment; filename=邮寄地址.csv");
    echo "姓名,性别,年龄,电话
    张三,男,23,15010125818";
    ?>
    

      注:echo中的逗号是每个列的分割标识符, 则是换行

    还有如下可参考:

    header("Content-type:application/vnd.ms-excel");
    header("Content-Disposition:filename=test.xls");
    

    PDF:

    <?php
    header("Content-type:application/pdf");
    
    // 文件将被称为 downloaded.pdf
    header("Content-Disposition:attachment;filename='downloaded.pdf'");
    
    // PDF 源在 original.pdf 中
    readfile("original.pdf");
    ?>
    

      

  • 相关阅读:
    pyspark创建RDD数据、RDD转DataFrame以及保存
    pyspark将DataFrame转成table以及操作sql语句
    pyspark读取textfile形成DataFrame以及查询表的属性信息
    sql-lab闯关之20-22
    sql-lib闯关之lesson17-19
    sql-lab闯关之13-16
    sql-lab闯关之11-12
    sql-lib闯关之lesson8-10
    sql-lab闯关之7
    sql-lib闯关之5-6
  • 原文地址:https://www.cnblogs.com/ouruola863/p/11737493.html
Copyright © 2020-2023  润新知