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

    /**
     * 使用spire簡(jiǎn)單整個(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);
    }

import com.spire.xls.FileFormat;
import com.spire.xls.Workbook;

    @Test
    public void test() {
        // Excel文件路徑
        String excelFilePath = "C:\\Users\\admin\\Downloads\\crossdock_plan_bol_2025-10-22 (1)\\test.xlsx";
        
        // 加載Excel文件
        Workbook workbook = new Workbook();
        workbook.loadFromFile(excelFilePath);
        
        // 構(gòu)造PDF文件路徑（與Excel文件同路徑，僅文件擴(kuò)展名不同）
        String pdfFilePath = excelFilePath.replaceAll("\\.xlsx$", ".pdf");

        // 保存為PDF到同路徑下
        workbook.saveToFile(pdfFilePath, FileFormat.PDF);
        
        System.out.println("PDF文件已保存到: " + pdfFilePath);
    }

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

<dependency>
    <groupId>e-iceblue</groupId>
    <artifactId>spire.pdf.free</artifactId>
    <version>9.13.0</version>
</dependency>

            String afterDestPdfFileName = "formal-" + middleFileName + ".pdf";
            AsposePdfUtil.replaceStr(attachRecordsThinVo.getDirectoryName().concat(destPdfFileName),
                    attachRecordsThinVo.getDirectoryName().concat(afterDestPdfFileName),
                    "Evaluation Only. Created with Aspose.Cells for Java.Copyright 2003 - 2023 Aspose Pty Ltd.");

    /**
     * 替換指定文字為白色的遮罩層
     * @param src 需要被轉(zhuǎn)換的帶全路徑文件名
     * @param dest 轉(zhuǎn)換之后pdf的帶全路徑文件名
     * @param replaceStr 指定轉(zhuǎn)換的文字(水印的文字)
     */
    public static void replaceStr(String src, String dest, String replaceStr) {
        try {
            List<String> resu = new ArrayList<>();
            PdfReader reader = new PdfReader(src);
            //獲取指定文字的坐標(biāo)(就是上一步生成的pdf水印)
            getKeyWords(reader,replaceStr,resu);
            PdfStamper stamper = new PdfStamper(reader, new FileOutputStream(dest));
            for (int i = 1; i <= resu.size(); i++) {
                String xy = resu.get(i - 1);
                PdfContentByte canvas = stamper.getOverContent(i);
//                canvas.showTextAligned(PdfContentByte.ALIGN_CENTER, "", 15, 15, 0);
//                canvas.set
                canvas.saveState();
                //設(shè)置顏色
                canvas.setColorFill(BaseColor.WHITE);
                //解析坐標(biāo)
                double x = Double.valueOf(xy.split("--")[0]);
                double y = Double.valueOf(xy.split("--")[1]) - 10;
                //后面2個(gè)參數(shù)分別是寬高
                canvas.rectangle(x, y, 450, 100);
                canvas.fill();
                canvas.restoreState();
            }
            stamper.close();
            reader.close();
        } catch (Exception e) {
            e.printStackTrace();
        }
    }

private  AttachRecords complex_fill_pod_excel_to_pdf(KeyVo keyVo, List<BaseVo> detailInfo, ResourceLoader resourceLoader, String fileName) throws IOException {
        log.info("complex_fill_pod_excel_to_pdf input param,keyVo:{},detailInfo:{},fileName:{}", JSONObject.toJSONString(keyVo),
                JSONObject.toJSONString(detailInfo), fileName);
        ByteArrayOutputStream bos = new ByteArrayOutputStream();
        try {
            // 模板注意 用{} 來(lái)表示你要用的變量 如果本來(lái)就有"{","}" 特殊字符 用"\{","\}"代替
            // {} 代表普通變量 {.} 代表是list的變量
            InputStream inputStream = resourceLoader.getResource(BOL_POD_TEMPLATE_NEW_FORMAT).getInputStream();
            ExcelWriter excelWriter = EasyExcel.write(bos).withTemplate(inputStream).build();
            WriteSheet writeSheet = EasyExcel.writerSheet().build();
            // 這里注意 入?yún)⒂昧薴orceNewRow 代表在寫入list的時(shí)候不管list下面有沒有空行 都會(huì)創(chuàng)建一行，然后下面的數(shù)據(jù)往后移動(dòng)。默認(rèn) 是false，會(huì)直接使用下一行，如果沒有則創(chuàng)建。
            // forceNewRow 如果設(shè)置了true,有個(gè)缺點(diǎn) 就是他會(huì)把所有的數(shù)據(jù)都放到內(nèi)存了，所以慎用
            // 簡(jiǎn)單的說(shuō) 如果你的模板有l(wèi)ist,且list不是最后一行，下面還有數(shù)據(jù)需要填充 就必須設(shè)置 forceNewRow=true 但是這個(gè)就會(huì)把所有數(shù)據(jù)放到內(nèi)存 會(huì)很耗內(nèi)存
            // 如果數(shù)據(jù)量大 list不是最后一行 參照下一個(gè)
            FillConfig fillConfig = FillConfig.builder().forceNewRow(Boolean.TRUE).build();
            excelWriter.fill(detailInfo, fillConfig, writeSheet);
            excelWriter.fill(keyVo, writeSheet);
            excelWriter.finish();



            if (ObjectUtil.isEmpty(bos) || bos.size() == 0){
                log.error("complex_fill_pod_excel_to_pdf error bos is null");
                return null;
            }

            String middleFileName = UUID.randomUUID().toString();
            // 生成原excel文件
            String sourceExcelFileName = "excel-" + middleFileName + ".xlsx";
            AttachRecordsThinVo attachRecordsThinVo = attachRecordsService.directSaveFile(sourceExcelFileName, bos.toByteArray());
            if (ObjectUtil.isEmpty(attachRecordsThinVo)){
                log.error("attachRecordsThinVo is null");
                return null;
            }

            // 轉(zhuǎn)成pdf
            String destPdfFileName = "temp-" + middleFileName + ".pdf";
            AsposePdfUtil.excel2pdf(attachRecordsThinVo.getDirectoryName().concat(sourceExcelFileName),
                    attachRecordsThinVo.getDirectoryName().concat(destPdfFileName), null);

            // 移除水印
            String afterDestPdfFileName = "formal-" + middleFileName + ".pdf";
            AsposePdfUtil.replaceStr(attachRecordsThinVo.getDirectoryName().concat(destPdfFileName),
                    attachRecordsThinVo.getDirectoryName().concat(afterDestPdfFileName),
                    "Evaluation Only. Created with Aspose.Cells for Java.Copyright 2003 - 2023 Aspose Pty Ltd.");

            // 本地生成的文件，上傳到阿里oss
            AttachRecords attachRecords = attachRecordsService.uploadAttachRecords(fileName,
                    attachRecordsThinVo.getDownloadDirectoryName().concat(afterDestPdfFileName),
                    FileUtils.readFileToByteArray(new File(attachRecordsThinVo.getDirectoryName().concat(afterDestPdfFileName))));

            log.info("complex_fill_pod_excel_to_pdf result attachRecords:{}",JSONObject.toJSONString(attachRecords));
            return attachRecords;
        } catch (Exception e) {
            log.error("complex_fill_pod_excel_to_pdf error!", e);
            e.printStackTrace();
            throw new ApiException(ResultCode.FAULT);
        } finally {
            bos.close();
        }
    }