我用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(':', '-')
);
}
}
