word、ppt、excel、txt转pdf——第三篇xls、xlsx

最新推荐文章于 2024-08-25 22:25:48 发布

清风过墙

最新推荐文章于 2024-08-25 22:25:48 发布

阅读量107

点赞数

文章标签： excel java

本文链接：https://blog.csdn.net/m0_38112475/article/details/129994760

版权

excel转pdf
用到了以下jar，License写在了文中。

<!-- excel工具 -->
<dependency>
    <groupId>org.apache.poi</groupId>
    <artifactId>poi</artifactId>
    <version>5.2.2</version>
</dependency>
<dependency>
    <groupId>aspose</groupId>
    <artifactId>cells</artifactId>
    <version>8.5.2</version>
</dependency>

下面上代码

package com.admin.util;

import java.io.ByteArrayInputStream;
import com.aspose.cells.SaveFormat;
import com.aspose.cells.Workbook;
import java.io.FileOutputStream;
import java.io.File;

/**
 * Excel转PDF
 */
public class ExcelToPdf {
    /**
     * 获取license
     */
    public static boolean isWordLicense() {
        boolean result = false;
        try {
            String s = "<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>";
            ByteArrayInputStream inputStream = new ByteArrayInputStream(s.getBytes());
            com.aspose.words.License license = new com.aspose.words.License();
            license.setLicense(inputStream);
            result = true;
        } catch (Exception e) {
            e.printStackTrace();
        }
        return result;
    }

    public static boolean ExcelToPdf(String Epath, String Opath) {
        boolean flag = false;
        // 验证License
        if (!isWordLicense()) {
            return false;
        }
        try {
            long start = System.currentTimeMillis();
            Workbook wb = new Workbook(Epath);// 原始excel路径
            File pdfFile = new File(Opath);// 输出路径
            FileOutputStream fileOS = new FileOutputStream(pdfFile);
            wb.save(fileOS, SaveFormat.PDF);
            long now = System.currentTimeMillis();
            System.out.println("共耗时：" + ((now - start) / 1000.0) + "秒");
            flag = true;
        } catch (Exception e) {
            e.printStackTrace();
        }
        return flag;
    }

    //测试方法
    public static void main(String[] args) {
        ExcelToPdf.ExcelToPdf("D:\\1.xls","D:\\x111.pdf");
    }
}