使用apache poi将Map<String、List<Map<String、Object>>>数据写入excel

XSSFWorkbook workbook = new XSSFWorkbook();

XSSFSheet sheet = workbook.createSheet("Sheet1");

Map<String, List<Map<String, Object>>> data = ...; // 输入的数据
Row headerRow = sheet.createRow(0);
int columnIndex = 0;
for (String key : data.keySet()) {
    Cell cell = headerRow.createCell(columnIndex);
    cell.setCellValue(key);
    columnIndex++;
}

int rowIndex = 1;
for (String key : data.keySet()) {
    List<Map<String, Object>> dataList = data.get(key);
    for (Map<String, Object> map : dataList) {
        Row dataRow = sheet.createRow(rowIndex);
        columnIndex = 0;
        for (String mapKey : map.keySet()) {
            Cell cell = dataRow.createCell(columnIndex);
            cell.setCellValue(map.get(mapKey).toString());
            columnIndex++;
        }
        rowIndex++;
    }
}

FileOutputStream outputStream = new FileOutputStream("output.xlsx");
workbook.write(outputStream);
outputStream.close();