<repositories>
    <repository>
        <id>com.e-iceblue</id>
        <name>e-iceblue</name>
        <url>https://repo.e-iceblue.com/nexus/content/groups/public/</url>
    </repository>
</repositories>
<dependencies>
    <dependency>
        <groupId>e-iceblue</groupId>
        <artifactId>spire.xls</artifactId>
        <version>15.7.7</version>
    </dependency>
</dependencies>

import com.spire.xls.*;

public class ExcelToPDF {
    public static void main(String[] args) {
        // 加載Excel文件
        Workbook workbook = new Workbook();
        workbook.loadFromFile("財(cái)務(wù)報(bào)表.xlsx");        
        
        // 轉(zhuǎn)換為PDF，保留完整工作表
        workbook.saveToFile("output.pdf", FileFormat.PDF);
        
        // 釋放資源
        workbook.dispose();
    }
}

// 選取Sheet1
Worksheet sheet = workbook.getWorksheets().get(0);

// 選取Sheet1的A1到F20區(qū)域
sheet.getPageSetup().setPrintArea("A1:F20");

// 執(zhí)行區(qū)域轉(zhuǎn)換
sheet.saveToPdf("區(qū)域報(bào)表.pdf",);

ExecutorService executor = Executors.newFixedThreadPool(4);
List<Path> excelFiles = getBatchFiles(); // 假設(shè)獲取批量文件路徑

for (Path file : excelFiles) {
    executor.execute(() -> {
        Workbook wb = new Workbook();
        try {
            wb.loadFromFile(file.toString());
            wb.saveToFile(file + ".pdf", FileFormat.PDF);
        } finally {
            wb.dispose(); // 必須釋放，避免內(nèi)存泄漏
        }
    });
}

PageSetup page = sheet.getPageSetup();
page.setLeftHeader("&"Calibri"&12&KFF0000 " + 
                   LocalDate.now() + " 機(jī)密文件"); // 紅色字體水印

// 添加LOGO（需圖片本地路徑）
page.setLeftHeaderImage("logo.png");
page.setLeftHeader("&G"); // &G表示圖片占位符

         <dependency>
             <groupId>e-iceblue</groupId>
             <artifactId>spire.xls.free</artifactId>
             <version>2.2.0</version>
         </dependency>

     /**
      * 使用spire簡單整個(gè)Excel轉(zhuǎn)換為pdf
      *
      * @param inputFilePath Excel文件路徑
      * @param outputFilePath 導(dǎo)出的PDF文件路徑
      */
     public static void totalExcelToPDF(String inputFilePath, String outputFilePath) {
         Workbook wb = new Workbook();
 //        引入Excel文件
         wb.loadFromFile(inputFilePath);
 //        導(dǎo)出PDF文件
         wb.saveToFile(outputFilePath, FileFormat.PDF);
     }

     /**
      * 使用spire將單個(gè)sheet轉(zhuǎn)成pdf
      *
      * @param inputFilePath Excel文件路徑
      * @param outputFilePath 導(dǎo)出的PDF文件路徑
      * @param sheetNum 導(dǎo)出的sheet頁下標(biāo)
      */
     public static void partExcelToPDF(String inputFilePath, String outputFilePath, int sheetNum) {
         //加載Excel文檔
         Workbook wb = new Workbook();
         wb.loadFromFile(inputFilePath);
         //獲取到哪一個(gè)sheet頁
         Worksheet sheet = wb.getWorksheets().get(sheetNum);
         //調(diào)用方法保存為PDF格式
         sheet.saveToPdf(outputFilePath);
     }

         <!--jacob依賴-->
         <dependency>
             <groupId>com.jacob</groupId>
             <artifactId>jacob</artifactId>
             <version>1.19</version>
             <scope>system</scope>
             <!--本地的jacob.jar的路徑-->
             <systemPath>D:\DevInstall\jacob18，19\jacob-1.19\jacob.jar</systemPath>
         </dependency>

 ?
     /**
      * 使用jacob實(shí)現(xiàn)excel轉(zhuǎn)PDF
      *
      * @param inputFilePath 導(dǎo)入Excel文件路徑
      * @param outputFilePath 導(dǎo)出PDF文件路徑
      */
     public static void jacobExcelToPDF(String inputFilePath, String outputFilePath) {
         ActiveXComponent ax = null;
         Dispatch excel = null;
 ?
         try {
             ComThread.InitSTA();
             ax = new ActiveXComponent("Excel.Application");
             ax.setProperty("Visible", new Variant(false));
 //        禁用宏
             ax.setProperty("AutomationSecurity", new Variant(3));
 ?
             Dispatch excels = ax.getProperty("Workbooks").toDispatch();
 ?
             Object[] obj = {
                     inputFilePath,
                     new Variant(false),
                     new Variant(false)
             };
 ?
             excel = Dispatch.invoke(excels, "Open", Dispatch.Method, obj, new int[9]).toDispatch();
 ?
 //        轉(zhuǎn)換格式
             Object[] obj2 = {
                     //                PDF格式等于0
                     new Variant(0),
                     outputFilePath,
                     //                0=標(biāo)準(zhǔn)（生成的PDF圖片不會(huì)模糊），1=最小的文件
                     new Variant(0)
             };
 ?
             Dispatch.invoke(excel, "ExportAsFixedFormat", Dispatch.Method, obj2, new int[1]);
 ?
         } catch (Exception e) {
             e.printStackTrace();
             throw e;
         } finally {
             if (excel != null) {
                 Dispatch.call(excel, "Close", new Variant(false));
             }
             if (ax != null) {
                 ax.invoke("Quit", new Variant[]{});
                 ax = null;
             }
             ComThread.Release();
         }
 ?
 ?
     }