<!-- Apache POI 用于讀取 Excel 文件 -->
<dependency>
    <groupId>org.apache.poi</groupId>
    <artifactId>poi</artifactId>
    <version>5.2.3</version>
</dependency>
<dependency>
    <groupId>org.apache.poi</groupId>
    <artifactId>poi-ooxml</artifactId>
    <version>5.2.3</version>
</dependency>
 
<!-- iText 用于生成 PDF 文件 -->
<dependency>
    <groupId>com.itextpdf</groupId>
    <artifactId>itextpdf</artifactId>
    <version>5.5.13.3</version>
</dependency>

import com.itextpdf.text.*;
import com.itextpdf.text.pdf.PdfPCell;
import com.itextpdf.text.pdf.PdfPTable;
import com.itextpdf.text.pdf.PdfWriter;
import org.apache.poi.ss.usermodel.*;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
 
import java.io.*;
 
public class ExcelToPdfConverter {
    public static void main(String[] args) {
        try {
            // 讀取 Excel 文件
            FileInputStream excelFile = new FileInputStream("input.xlsx");
            Workbook workbook = new XSSFWorkbook(excelFile);
            Sheet sheet = workbook.getSheetAt(0);
 
            // 創(chuàng)建 PDF 文檔
            Document document = new Document();
            PdfWriter.getInstance(document, new FileOutputStream("output.pdf"));
            document.open();
 
            // 創(chuàng)建 PDF 表格，列數(shù)與 Excel 表格的列數(shù)相同
            int columnCount = sheet.getRow(0).getLastCellNum();
            PdfPTable pdfTable = new PdfPTable(columnCount);
 
            // 遍歷 Excel 表格的每一行
            for (Row row : sheet) {
                // 遍歷當(dāng)前行的每一個(gè)單元格
                for (Cell cell : row) {
                    // 獲取單元格的值
                    String cellValue = getCellValueAsString(cell);
                    // 創(chuàng)建 PDF 表格的單元格
                    PdfPCell pdfCell = new PdfPCell(new Phrase(cellValue));
                    // 將單元格添加到 PDF 表格中
                    pdfTable.addCell(pdfCell);
                }
            }
 
            // 將 PDF 表格添加到 PDF 文檔中
            document.add(pdfTable);
 
            // 關(guān)閉文檔和 Excel 文件
            document.close();
            workbook.close();
            excelFile.close();
 
            System.out.println("Excel 轉(zhuǎn) PDF 成功！");
        } catch (Exception e) {
            e.printStackTrace();
            System.out.println("Excel 轉(zhuǎn) PDF 失敗：" + e.getMessage());
        }
    }
 
    // 將單元格的值轉(zhuǎn)換為字符串
    private static String getCellValueAsString(Cell cell) {
        if (cell == null) {
            return "";
        }
        switch (cell.getCellType()) {
            case STRING:
                return cell.getStringCellValue();
            case NUMERIC:
                if (DateUtil.isCellDateFormatted(cell)) {
                    return cell.getDateCellValue().toString();
                } else {
                    return String.valueOf(cell.getNumericCellValue());
                }
            case BOOLEAN:
                return String.valueOf(cell.getBooleanCellValue());
            case FORMULA:
                return cell.getCellFormula();
            default:
                return "";
        }
    }
}