通过phpoffice将word与excel文件转成PDF文件

最新推荐文章于 2024-06-25 18:05:06 发布

swoole~

最新推荐文章于 2024-06-25 18:05:06 发布

阅读量1.2k

点赞数 7

文章标签： word excel pdf

本文链接：https://blog.csdn.net/wyh757787026/article/details/136597457

版权

本文介绍了如何在PHP项目中使用Composer安装phpoffice/phpword和phpoffice/phpspreadsheet库，以及如何实现将Word和Excel文件转换为PDF的功能，包括设置PDF渲染器和保存转换后的PDF文件。

摘要由CSDN通过智能技术生成

1.首先需要对应的库

composer require phpoffice/phpword
composer require phpoffice/phpspreadsheet
composer require mpdf/mpdf

2.相关代码如下

<?php

namespace common;

use PhpOffice\PhpWord\PhpWord;
use PhpOffice\PhpWord\IOFactory;
use PhpOffice\PhpWord\Settings;
use PhpOffice\PhpSpreadsheet\IOFactory as SpreadIoFactory;
use PhpOffice\PhpPresentation\IOFactory as PowerpointIoFactory;
use common\PDF;

/**
 * 提供Office管理服务
 * @name Office.php
 * @package jypp
 * @category model
 * @link http://www.chanekeji.com
 * @author mengchen
 * @version 1.0
 * @copyright CHANGE INC
 * @since 2023-02-15
 */
class Office
{   
    /**
     * word转pdf
     * @param string $wordPath 
     * @param string $fileName
     */
    public function wordToPdf($wordPath = '',$fileName = 'output')
    {   
        // 设置具体存放路径
        $basePath = sprintf('%spublic/upload/pdf/%s',ROOT_PATH,date('Ymd'));
        $path = sprintf('%s/%s.pdf',$basePath,$fileName);
        if (!file_exists($basePath)) {
            mkdir($basePath, 0755, true); //创建目录
        }
        // 创建一个新的 PHPWord 实例
        $phpWord = new PhpWord();
        Settings::setPdfRendererPath(sprintf('%svendor/mpdf/mpdf',ROOT_PATH));
        //设置转换pdf的类库名（DomPDF、MPDF、TCPDF）需要下载对应的类库
        Settings::setPdfRendererName('MPDF');
        // 从 Word 文档中加载内容
        $wordReader = IOFactory::createReader('Word2007');
        $phpWord = $wordReader->load($wordPath);

        // 用 PHPWord 创建 PDF 文件
        $xmlWriter = IOFactory::createWriter($phpWord, 'PDF');
        $xmlWriter->save($path);
        if(file_exists($path)){
            $pdf = new PDF();
            $pngs = $pdf->pdfToPng($path);
            if(count($pngs) > 0){
                unlink($path);
                return $pngs;
            }
            return [];
        }else{
            return [];
        }
    }

    /**
     * excel转pdf
     * @param string $wordPath 
     * @param string $fileName
     */
    public function excelToPdf($excelPath = '',$fileName = 'output')
    {   
        // 设置具体存放路径
        $basePath = sprintf('%spublic/upload/pdf/%s',ROOT_PATH,date('Ymd'));
        $path = sprintf('%s/%s.pdf',$basePath,$fileName);
        if (!file_exists($basePath)) {
            mkdir($basePath, 0755, true); //创建目录
        }
        
        /*第一步：打开excel文件*/
        $Excelreader = SpreadIoFactory::createReaderForFile($excelPath);
        $ExcelObj= $Excelreader ->load($excelPath);//打开后的excel对象
        
        /*第二步：另存为pdf文件*/
        $PDFWriter = SpreadIoFactory::createWriter($ExcelObj,'Mpdf');
        $PDFWriter ->save($path);
        if(file_exists($path)){
            $pdf = new PDF();
            $pngs = $pdf->pdfToPng($path);
            if(count($pngs) > 0){
                unlink($path);
                return $pngs;
            }
            return [];
        }else{
            return [];
        }
    }
}