<dependencies>
    <!-- Apache POI for Excel (xlsx) -->
    <dependency>
        <groupId>org.apache.poi</groupId>
        <artifactId>poi-ooxml</artifactId>
        <version>5.2.3</version>
    </dependency>
    <!-- Apache POI for Excel (xls) -->
    <dependency>
        <groupId>org.apache.poi</groupId>
        <artifactId>poi</artifactId>
        <version>5.2.3</version>
    </dependency>
</dependencies>

import org.apache.poi.ss.usermodel.*;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
 
import java.io.*;
import java.util.*;
 
public class ExcelExportExample {
 
    public static void main(String[] args) {
        // 示例數(shù)據(jù)：可以從數(shù)據(jù)庫(kù)、文件等獲取
        List<Map<String, Object>> data = getData();
 
        // 創(chuàng)建Excel文件
        try (FileOutputStream fileOut = new FileOutputStream("report.xlsx")) {
            Workbook workbook = new XSSFWorkbook(); // 創(chuàng)建Excel工作簿
            Sheet sheet = workbook.createSheet("Report"); // 創(chuàng)建工作表
 
            // 創(chuàng)建表頭
            createHeaderRow(sheet);
 
            // 填充數(shù)據(jù)
            fillData(sheet, data);
 
            // 將Excel文件寫入磁盤
            workbook.write(fileOut);
            System.out.println("Excel file generated successfully.");
        } catch (IOException e) {
            e.printStackTrace();
        }
    }
 
    // 創(chuàng)建表頭
    private static void createHeaderRow(Sheet sheet) {
        Row headerRow = sheet.createRow(0); // 表頭行
        String[] columns = {"ID", "Name", "Age", "Department"};
 
        for (int i = 0; i < columns.length; i++) {
            Cell cell = headerRow.createCell(i);
            cell.setCellValue(columns[i]);
            // 設(shè)置表頭字體為粗體
            CellStyle style = sheet.getWorkbook().createCellStyle();
            Font font = sheet.getWorkbook().createFont();
            font.setBold(true);
            style.setFont(font);
            cell.setCellStyle(style);
        }
    }
 
    // 填充數(shù)據(jù)到Excel表格
    private static void fillData(Sheet sheet, List<Map<String, Object>> data) {
        int rowNum = 1; // 從第二行開(kāi)始填充數(shù)據(jù)
        for (Map<String, Object> rowData : data) {
            Row row = sheet.createRow(rowNum++);
            int cellNum = 0;
 
            // 填充每一列的數(shù)據(jù)
            row.createCell(cellNum++).setCellValue((Integer) rowData.get("id"));
            row.createCell(cellNum++).setCellValue((String) rowData.get("name"));
            row.createCell(cellNum++).setCellValue((Integer) rowData.get("age"));
            row.createCell(cellNum++).setCellValue((String) rowData.get("department"));
        }
    }
 
    // 示例數(shù)據(jù)，可以從數(shù)據(jù)庫(kù)獲取
    private static List<Map<String, Object>> getData() {
        List<Map<String, Object>> data = new ArrayList<>();
 
        // 模擬一些數(shù)據(jù)
        Map<String, Object> row1 = new HashMap<>();
        row1.put("id", 1);
        row1.put("name", "John Doe");
        row1.put("age", 30);
        row1.put("department", "IT");
 
        Map<String, Object> row2 = new HashMap<>();
        row2.put("id", 2);
        row2.put("name", "Jane Smith");
        row2.put("age", 25);
        row2.put("department", "HR");
 
        data.add(row1);
        data.add(row2);
 
        return data;
    }
}