java实现excel转pdf文件

曾经终败给现在 2023-09-29 18:32 14阅读 0赞

### 引入依赖pom.xml ###

<dependency>
        <groupId>com.aspose.cells</groupId>
        <artifactId>aspose-cells</artifactId>
        <version>8.5.2</version>
    </dependency>

### 项目目录 Resource 下添加 license.xml 文件 ###

<License>
      <Data>
        <Products>
          <Product>Aspose.Total for Java</Product>
          <Product>Aspose.Words for Java</Product>
        </Products>
        <EditionType>Enterprise</EditionType>
        <SubscriptionExpiry>20991231</SubscriptionExpiry>
        <LicenseExpiry>20991231</LicenseExpiry>
        <SerialNumber>8bfe198c-7f0c-4ef8-8ff0-acc3237bf0d7</SerialNumber>
      </Data>
     <Signature>
    sNLLKGMUdF0r8O1kKilWAGdgfs2BvJb/2Xp8p5iuDVfZXmhppo+d0Ran1P9TKdjV4ABwAgKXxJ3jcQTqE/2IRfqwnPf8itN8aFZlV3TJPYeD3yWE7IT55Gz6EijUpC7aKeoohTb4w2fpox58wWoF3SNp6sK6jDfiAUGEHYJ9pjU=
     </Signature>
    </License>

### 测试 ###

public static void main(String[] args) {
    	// 本地excel路径
        String excelFilePath = "D:\\excelTest.xlsx";
        // 输出文件路径
        String pdfFilePath = "D:\\pdfTest.pdf";
        // sheet页
        int showSheets = 0;
        try {
        	// 验证License 若不验证则转化出的pdf文档会有水印产生
        	InputStream license = ExcelUtil.class.getClassLoader().getResourceAsStream("license.xml");
        	License aposeLic = new License();
            aposeLic.setLicense(license);
    
            Workbook wb = new Workbook(excelFilePath);
            FileOutputStream fileOS = new FileOutputStream(pdfFilePath);
            PdfSaveOptions pdfSaveOptions = new PdfSaveOptions();
            //设置合规性类型
            pdfSaveOptions.setOnePagePerSheet(false);
            pdfSaveOptions.setMergeAreas(true);
    
            // 选择输出的的sheet页
            for (int i = 1; i < wb.getWorksheets().getCount(); i++) {
            	wb.getWorksheets().get(i).setVisible(false);
            }
            if (showSheets == 0) {
            	wb.getWorksheets().get(0).setVisible(true);
            } else {
            	for (int i = 0; i <= showSheets; i++) {
            		wb.getWorksheets().get(i).setVisible(true);
                    System.out.println("第" + i + "页");
            	}
            }
            wb.save(fileOS, pdfSaveOptions);
            fileOS.flush();
            fileOS.close();
        } catch (Exception e) {
        	e.printStackTrace();
        }
    }

### excel模板 ###

![6ed5ce7816014d769e3811d6387b6c2f.png][]

### 生成pdf ###

![fc39209a8a384960964b3a396ed0b99c.png][]

[6ed5ce7816014d769e3811d6387b6c2f.png]: https://img-blog.csdnimg.cn/6ed5ce7816014d769e3811d6387b6c2f.png
[fc39209a8a384960964b3a396ed0b99c.png]: https://img-blog.csdnimg.cn/fc39209a8a384960964b3a396ed0b99c.png