<dependency>  
    <groupId>org.apache.poi</groupId>  
    <artifactId>poi</artifactId>  
    <version>5.0.0</version>  
</dependency>  
<dependency>  
    <groupId>org.apache.poi</groupId>  
    <artifactId>poi-ooxml</artifactId>  
    <version>5.0.0</version>  
</dependency>

import org.apache.poi.ss.usermodel.*;  
import org.apache.poi.xssf.usermodel.XSSFWorkbook;  
  
import java.io.FileOutputStream;  
import java.io.IOException;  
import java.util.List;  
  
public class ExcelExportService {  
  
    public void exportToExcel(List<?> dataList, String[] headers, String fileName) {  
        Workbook workbook = new XSSFWorkbook(); // 創(chuàng)建工作簿  
        Sheet sheet = workbook.createSheet("Sheet1"); // 創(chuàng)建工作表  
  
        // 創(chuàng)建表頭  
        Row headerRow = sheet.createRow(0);  
        for (int i = 0; i < headers.length; i++) {  
            Cell headerCell = headerRow.createCell(i);  
            headerCell.setCellValue(headers[i]);  
        }  
  
        // 填充數(shù)據(jù)  
        int rowNum = 1;  
        for (Object data : dataList) {  
            Row row = sheet.createRow(rowNum++);  
            // 假設(shè)data是一個Map，包含了要導(dǎo)出的字段和值  
            if (data instanceof Map) {  
                Map<?, ?> dataMap = (Map<?, ?>) data;  
                int cellNum = 0;  
                for (String header : headers) {  
                    Cell cell = row.createCell(cellNum++);  
                    if (dataMap.containsKey(header)) {  
                        cell.setCellValue(dataMap.get(header).toString());  
                    }  
                }  
            }  
        }  
  
        // 寫入文件  
        try (FileOutputStream outputStream = new FileOutputStream(fileName)) {  
            workbook.write(outputStream);  
        } catch (IOException e) {  
            e.printStackTrace();  
        } finally {  
            try {  
                workbook.close();  
            } catch (IOException e) {  
                e.printStackTrace();  
            }  
        }  
    }  
}

import org.springframework.beans.factory.annotation.Autowired;  
import org.springframework.stereotype.Controller;  
import org.springframework.web.bind.annotation.GetMapping;  
  
import java.util.Arrays;  
import java.util.HashMap;  
import java.util.List;  
import java.util.Map;  
  
@Controller  
public class ExcelExportController {  
  
    @Autowired  
    private ExcelExportService excelExportService;  
  
    @GetMapping("/export")  
    public String exportData() {  
        // 模擬數(shù)據(jù)  
        List<Map<String, Object>> dataList = Arrays.asList(  
                new HashMap<String, Object>() {{  
                    put("Name", "Alice");  
                    put("Age", 25);  
                }},  
                new HashMap<String, Object>() {{  
                    put("Name", "Bob");  
                    put("Age", 30);  
                }}  
        );  
  
        // 表頭  
        String[] headers = {"Name", "Age"};  
  
        // 導(dǎo)出文件路徑  
        String fileName = "data.xlsx";  
  
        // 調(diào)用服務(wù)導(dǎo)出數(shù)據(jù)  
        excelExportService.exportToExcel(dataList, headers, fileName);

        // 提示用戶下載文件（這里假設(shè)你在前端有相應(yīng)的邏輯來處理文件下載）  
        return "redirect:/download/" + fileName;  
    }
}