主页 / 问题 / 983833
Accepted
Max Lich
Asked:2020-05-21 17:07:32 +0000 UTC2020-05-21 17:07:32 +0000 UTC

为什么在 Excel 导出中出现错误 org.springframework.web.HttpMediaTypeNotAcceptableException：找不到可接受的表示？

  • 772

我用apache poi它上传到MS Excel. 我也用Spring. 库版本：

<springframework.boot>2.1.2.RELEASE</springframework.boot>
<springframework.version>5.1.4.RELEASE</springframework.version>
<apache-poi.version>4.0.1</apache-poi.version>

在控制器中提交文件时，出现错误：

   ERROR] 2019-05-21 11:50:45.992 [http-nio-9999-exec-2] RestExceptionHandler - Could not find acceptable representation
org.springframework.web.HttpMediaTypeNotAcceptableException: Could not find acceptable representation

这是我的控制器代码：

 @RestController
@RequestMapping(produces = "application/vnd.ms-excel")
@Api(tags = {"ExportToMsExcelController"}, description = "Выгрузка в MS Excel"/*, produces = "application/vnd.ms-excel"*/)
public class ExportToMsExcelController {

    private final static Logger logger = LogManager.getLogger(ExportToMsExcelController.class);

    private static final String REQUEST_FILE_PREFIX = "RequestRegistry";

    private CreateRequestXLSXDocumentService createRequestXLSXDocumentService;

    @Autowired
    public void setCreateRequestXLSXDocumentService(CreateRequestXLSXDocumentService createRequestXLSXDocumentService) {
        this.createRequestXLSXDocumentService = createRequestXLSXDocumentService;
    }

    @ResponseStatus(HttpStatus.OK)
    @GetMapping(value = "/requests/list/ms-excel")
    @ApiOperation(value = "Экспортирует таблицу \"Реестр заявлений\" в MS Excel",
            notes = "Экспортирует данные таблицы \"Реестр заявлений\" в файл в формате MS Excel")
    public ResponseEntity<InputStreamResource> exportRequestTable(
            @ApiParam(value = "Optional String sort (example atr-,atr2,atr3)", name = "sort") @RequestParam(value = "sort", required = false) String sort,
            @ApiParam(value = "Optional String search (example evId==541)", name = "search") @RequestParam(value = "search", required = false) String search
    ) {

        Map<String, Object> param = new HashMap<>();

        final long startTime = System.currentTimeMillis();

        Optional.ofNullable(sort).ifPresent(s -> param.put("sort", s));

        Optional.ofNullable(search).ifPresent(s -> param.put("search", s));

        byte[] fileCont;
        try {
            fileCont = createRequestXLSXDocumentService.createXLSXDocument(param);
        } catch (Exception ex) {
            logger.error(ex.toString(), ex);
            throw new RuntimeException(ex.getMessage(), ex);
        }

        final ByteArrayInputStream in = new ByteArrayInputStream(fileCont);

        final String fileName = generateFileName(REQUEST_FILE_PREFIX);

        HttpHeaders headers = new HttpHeaders();
        // set filename in header
        headers.add(HttpHeaders.CONTENT_DISPOSITION, "attachment; filename=" + fileName);

        final long endTime = System.currentTimeMillis();

        logger.info("Общее время работы: " + ((endTime - startTime) / 1000) + " сек");

        return ResponseEntity
                .ok()
                .headers(headers)
                .contentLength(fileCont.length)
                .contentType(MediaType.parseMediaType("application/vnd.ms-excel"))
                .body(new InputStreamResource(in));
    }

    /**
     * Генерирует имя файла
     *
     * @param prefix префикс в имени файла
     * @return сгенерированное имя файла
     */
    private String generateFileName(String prefix) {
        return String.format("%s_%s.xlsx", prefix,
                LocalDateTime.now()
                        .toString()
                        .replace(':', '-')
        );
    }
}
java

1 个回答

  1. Best Answer

    HttpMessageConverter我通过在配置中添加另一个解决了这个问题Spring：

    ...
 @Bean
    public WebMvcConfigurer webMvcConfigurer() {
        return new WebMvcConfigurer() {

            @Override
            public void configureMessageConverters(List<HttpMessageConverter<?>> converters) {
                converters.add(stringConverter());
                converters.add(mappingJackson2HttpMessageConverter());
                converters.add(excelConverter());
            }

...
}

...

    @Bean
    public ResourceHttpMessageConverter excelConverter() {
        final ResourceHttpMessageConverter converter = new ResourceHttpMessageConverter();
        converter.setSupportedMediaTypes(
                List.of(new MediaType("application", "vnd.ms-excel"))
        );
        return converter;
    }

    我还稍微更改了控制器中的方法代码（返回一个值）：

    ....
      return ResponseEntity
                .ok()
                .headers(headers)
                .contentLength(fileCont.length)
                .contentType(new MediaType("application", "vnd.ms-excel"))
                .body(new InputStreamResource(in));
      }
}
    • 1

相关问题