java - 如何使用 Spring Boot 返回 jasper 生成的 excel 类型

Question

我有这个方法，它返回一个字节数组中的pdf，我想生成一个excel类型。我怎样才能做到这一点？在“headers.setContentType”中没有我可以使用的 csv 或 xls 类型。

public ResponseEntity<byte[]> imprimir(List<Notificacao> notificacoes) throws Exception {

    JasperReport report = JasperCompileManager.compileReport(this.getPathToReportPackage() + "notificacoes.jrxml");

    JasperPrint print = JasperFillManager.fillReport(report, null, new JRBeanCollectionDataSource(notificacoes));

    byte[] bytes = JasperExportManager.exportReportToPdf(print);

    HttpHeaders headers = new HttpHeaders();
    headers.setContentType(MediaType.APPLICATION_PDF);
    String filename = "notificacao.pdf";
    headers.setContentDispositionFormData(filename, filename);
    headers.setCacheControl("must-revalidate, post-check=0, pre-check=0");
    ResponseEntity<byte[]> response = new ResponseEntity<>(bytes, headers, HttpStatus.OK);

    return response;

}

Answer 1

Excel:

headers.setContentType(MediaType.parseMediaType("application/vnd.ms-excel"));

CSV:

headers.setContentType(MediaType.parseMediaType("text/csv"));

您可以在此链接上找到 Mime 类型的完整列表。

https://slick.pl/kb/htaccess/complete-list-mime-types/