Excel Export Enum Replacer

Problem

When exporting domain objects to Excel, enum or code fields (e.g. status codes, boolean flags) must be displayed as human-readable labels. Embedding this mapping inside the DTO or service layer couples presentation concerns to business logic.

Pattern

• Build a DataToBeReplace object that maps raw field values to display strings, keyed by DTO field name.
• Pass it alongside the column definitions and data list to ExcelExportManager.objectToExcelAndDownload(...).
• The export manager applies the replacement during cell rendering, keeping DTOs and services unaware of Excel-specific labels.
• The endpoint returns ResponseEntity<Resource> with a Content-Disposition: attachment header and an appropriate MIME type.

Example (sanitized)

// Controller method
@PostMapping("/items/list-filter-excel")
@FunctionId({FunctionIds.ITEM_EXCEL})
public ResponseEntity<Resource> downloadItemsExcel(
    @RequestBody ExportParameterDto parameter) throws UnsupportedEncodingException {

    // Force full-page query for export
    parameter.getFiltersPageableDto().setPageNumber(1);
    parameter.getFiltersPageableDto().setPagePerSize(Integer.MAX_VALUE);

    Criteria criteria = CriteriaMakeHelper.INSTANCE
        .gridFiltersToCriteria(parameter.getFiltersPageableDto().getGridFilters());
    Page<ItemDto> items = itemService.findByCriteria(criteria,
        parameter.getFiltersPageableDto().toPageable());

    // Build enum-to-label replacement map
    DataToBeReplace replaceData = DataToBeReplace.builder()
        .replaceData("status", Map.of(
            "ACTIVE",   "Active",
            "INACTIVE", "Inactive",
            "PENDING",  "Pending"
        ))
        .replaceData("permission", Map.of(
            Boolean.TRUE,  "Allowed",
            Boolean.FALSE, "Denied"
        ))
        .build();

    byte[] excelBytes = excelExportManager.objectToExcelAndDownload(
        parameter.getGridColumnDataDto().getColumnDefs(), // List<ColumnDef>
        items.getContent(),                               // List<?>
        replaceData,
        0,                                                // sheet index
        "yyyy-MM-dd HH:mm:ss"                            // date format
    );

    String encodedFilename = UriUtils.encode("items.xlsx", StandardCharsets.UTF_8);
    return ResponseEntity.ok()
        .header(HttpHeaders.CONTENT_DISPOSITION,
            "attachment; filename*=UTF-8''" + encodedFilename)
        .contentType(MediaType.APPLICATION_OCTET_STREAM)
        .body(new ByteArrayResource(excelBytes));
}