<dependencies>
    <!-- Spring Boot Web -->
    <dependency>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-web</artifactId>
    </dependency>
    
    <!-- EasyPOI（Excel 導(dǎo)出） -->
    <dependency>
        <groupId>cn.afterturn</groupId>
        <artifactId>easypoi-base</artifactId>
        <version>4.4.0</version> <!-- 最新穩(wěn)定版 -->
    </dependency>
    <dependency>
        <groupId>cn.afterturn</groupId>
        <artifactId>easypoi-web</artifactId>
        <version>4.4.0</version>
    </dependency>
    
    <!-- Aspose.Cells（Excel 轉(zhuǎn) PDF） -->
    <dependency>
        <groupId>com.aspose</groupId>
        <artifactId>aspose-cells</artifactId>
        <version>23.10</version>
    </dependency>
    
    <!-- Aspose.Words（Word 轉(zhuǎn) PDF） -->
    <dependency>
        <groupId>com.aspose</groupId>
        <artifactId>aspose-words</artifactId>
        <version>23.10</version>
    </dependency>
</dependencies>

@Data
@TableName("sys_employee")
// Excel 導(dǎo)出配置（文件名、工作表名）
@ExcelEntity(name = "員工信息表", sheetName = "員工信息")
public class Employee {
    @Excel(name = "ID", orderNum = "0", width = 10)  // 列名、順序、列寬
    private Long id;

    @Excel(name = "姓名", orderNum = "1", width = 15)
    private String name;

    @Excel(name = "年齡", orderNum = "2", width = 10, replace = {"0_未知", "1_男", "2_女"})  // 數(shù)據(jù)替換
    private Integer gender;

    @Excel(name = "部門", orderNum = "3", width = 20)
    private String department;

    @Excel(name = "入職時間", orderNum = "4", width = 20, format = "yyyy-MM-dd")  // 日期格式
    private Date hireDate;
}

@Component
public class ExcelExportUtils {
    private static final Logger log = LoggerFactory.getLogger(ExcelExportUtils.class);

    /**
     * 生成 Excel Workbook（基于 EasyPOI）
     * @param dataList 數(shù)據(jù)列表
     * @param entityClass 實體類（含 @ExcelEntity 注解）
     * @return Workbook
     */
    public static <T> Workbook generateExcelWorkbook(List<T> dataList, Class<T> entityClass) {
        ExportParams exportParams = new ExportParams();
        exportParams.setSheetName("員工信息");  // 工作表名（與 @ExcelEntity 一致）
        exportParams.settitle("員工信息表");    // Excel 標(biāo)題（頂部大標(biāo)題）

        // 使用 EasyPOI 生成 Workbook
        return ExcelExportUtil.exportExcel(exportParams, entityClass, dataList);
    }
}

@Component
public class ExcelToPdfConverter {
    private static final Logger log = LoggerFactory.getLogger(ExcelToPdfConverter.class);

    /**
     * 將 Workbook 轉(zhuǎn)換為 PDF 字節(jié)流（Aspose.Cells）
     * @param workbook Excel Workbook
     * @return PDF 字節(jié)流
     */
    public static ByteArrayOutputStream convertToPdf(Workbook workbook) throws Exception {
        // 1. 創(chuàng)建 PDF 保存選項（可選配置）
        PdfSaveOptions saveOptions = new PdfSaveOptions();
        saveOptions.setOnePagePerSheet(true);       // 每個工作表一頁
        saveOptions.setFormat(PdfFormat.PdfA2B);    // 符合 PDF/A-2B 標(biāo)準(zhǔn)（可選）
        saveOptions.setCompressImages(true);        // 壓縮圖片（減小文件大?。?
        saveOptions.setImageCompression(PdfImageCompressionType.MEDIUM);  // 圖片壓縮級別

        // 2. 轉(zhuǎn)換為 PDF 字節(jié)流
        ByteArrayOutputStream pdfOutputStream = new ByteArrayOutputStream();
        workbook.save(pdfOutputStream, saveOptions);
        return pdfOutputStream;
    }
}

@RestController
@RequestMapping("/export")
public class ExportController {
    @Autowired
    private ExcelExportUtils excelExportUtils;
    @Autowired
    private ExcelToPdfConverter pdfConverter;

    @GetMapping("/excel-to-pdf")
    public void exportEmployeeToPdf(HttpServletResponse response) throws Exception {
        // 1. 模擬數(shù)據(jù)（實際從數(shù)據(jù)庫查詢）
        List<Employee> dataList = new ArrayList<>();
        dataList.add(new Employee(1L, "張三", 25, "技術(shù)部", new Date()));
        dataList.add(new Employee(2L, "李四", 30, "市場部", new Date()));

        // 2. 生成 Excel Workbook（EasyPOI）
        Workbook workbook = excelExportUtils.generateExcelWorkbook(dataList, Employee.class);

        // 3. 轉(zhuǎn)換為 PDF 字節(jié)流（Aspose.Cells）
        ByteArrayOutputStream pdfOutputStream = pdfConverter.convertToPdf(workbook);

        // 4. 設(shè)置響應(yīng)頭（下載 PDF）
        response.setContentType("application/pdf");
        response.setHeader("Content-Disposition", "attachment; filename=employee_report.pdf");
        response.getOutputStream().write(pdfOutputStream.toByteArray());
        response.getOutputStream().flush();
        response.getOutputStream().close();
    }
}

@Component
public class WordDocumentBuilder {
    private static final Logger log = LoggerFactory.getLogger(WordDocumentBuilder.class);

    /**
     * 構(gòu)建 Word 文檔（Aspose.Words）
     * @param content 文檔內(nèi)容（文本+表格）
     * @return Document（Aspose.Words 文檔對象）
     */
    public static Document buildWordDocument(String content) throws Exception {
        // 創(chuàng)建空白文檔
        Document doc = new Document();
        DocumentBuilder builder = new DocumentBuilder(doc);

        // 寫入標(biāo)題
        builder.getFont().setName("微軟雅黑");
        builder.getFont().setSize(16);
        builder.getFont().setBold(true);
        builder.writeln("員工信息報告");

        // 寫入正文
        builder.getFont().setSize(12);
        builder.getFont().setBold(false);
        builder.writeln("以下是近期員工信息：");
        builder.writeln();

        // 寫入表格（示例數(shù)據(jù)）
        builder.startTable();
        builder.insertCell();
        builder.write("ID");
        builder.insertCell();
        builder.write("姓名");
        builder.insertCell();
        builder.write("部門");
        builder.endRow();

        builder.insertCell();
        builder.write("1");
        builder.insertCell();
        builder.write("張三");
        builder.insertCell();
        builder.write("技術(shù)部");
        builder.endRow();

        builder.endTable();

        return doc;
    }
}

@Component
public class WordToPdfConverter {
    private static final Logger log = LoggerFactory.getLogger(WordToPdfConverter.class);

    /**
     * 將 Aspose.Words Document 轉(zhuǎn)換為 PDF 字節(jié)流
     * @param document Word 文檔對象
     * @return PDF 字節(jié)流
     */
    public static ByteArrayOutputStream convertToPdf(Document document) throws Exception {
        // 1. 配置 PDF 保存選項（可選）
        PdfSaveOptions saveOptions = new PdfSaveOptions();
        saveOptions.setCompressFonts(true);       // 壓縮字體
        saveOptions.setUseHighQualityRendering(true);  // 高質(zhì)量渲染

        // 2. 轉(zhuǎn)換為 PDF 字節(jié)流
        ByteArrayOutputStream pdfOutputStream = new ByteArrayOutputStream();
        document.save(pdfOutputStream, saveOptions);
        return pdfOutputStream;
    }
}

@RestController
@RequestMapping("/export")
public class ExportController {
    @Autowired
    private WordDocumentBuilder wordBuilder;
    @Autowired
    private WordToPdfConverter wordPdfConverter;

    @GetMapping("/word-to-pdf")
    public void exportEmployeeToPdf(HttpServletResponse response) throws Exception {
        // 1. 構(gòu)建 Word 文檔（Aspose.Words）
        String content = "員工信息報告內(nèi)容...";  // 實際從數(shù)據(jù)庫或業(yè)務(wù)邏輯獲取
        Document wordDoc = wordBuilder.buildWordDocument(content);

        // 2. 轉(zhuǎn)換為 PDF 字節(jié)流（Aspose.Words）
        ByteArrayOutputStream pdfOutputStream = wordPdfConverter.convertToPdf(wordDoc);

        // 3. 設(shè)置響應(yīng)頭（下載 PDF）
        response.setContentType("application/pdf");
        response.setHeader("Content-Disposition", "attachment; filename=employee_report.pdf");
        response.getOutputStream().write(pdfOutputStream.toByteArray());
        response.getOutputStream().flush();
        response.getOutputStream().close();
    }
}

// 調(diào)用 LibreOffice 轉(zhuǎn)換 Excel 到 PDF
public static void convertExcelToPdfWithLibreOffice(String excelPath, String pdfPath) throws IOException {
    String command = String.format(
        "libreoffice --headless --convert-to pdf --outdir %s %s",
        pdfPath, excelPath
    );
    Process process = Runtime.getRuntime().exec(command);
    int exitCode = process.waitFor();
    if (exitCode != 0) {
        throw new RuntimeException("LibreOffice 轉(zhuǎn)換失敗");
    }
}