1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

public static ResponseEntity<FileSystemResource> export(File file) throws UnsupportedEncodingException {

        if (file == null) {

            return null;

        }

        //这个位置对文件名进行编码

        String fileName = new String (file.getName().getBytes("GBK"),"ISO-8859-1");

        HttpHeaders headers = new HttpHeaders();

        headers.add("Cache-Control", "no-cache, no-store, must-revalidate");

        headers.add("Content-Disposition", "attachment; filename=" +fileName);

        headers.add("Pragma", "no-cache");

        headers.add("Expires", "0");

        headers.add("Last-Modified", new Date().toString());

        headers.add("ETag", String.valueOf(System.currentTimeMillis()));

        return ResponseEntity

                .ok()

                .headers(headers)

                .contentLength(file.length())

                .contentType(MediaType.parseMediaType("application/octet-stream"))

                .body(new FileSystemResource(file));

    }

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

public static void exportToExcel(String uid, String name, String htmlText, 

HttpServletRequest request, HttpServletResponse response) {

      htmlText = htmlText.replaceFirst("<table>", "<tableFirst>");

      htmlText = htmlText.replaceAll("<table>",

            "<table cellpadding=\"3\" cellspacing=\"0\"  border=\"1\" rull=\"all\" 

style=\"border-collapse: collapse\">");

      htmlText = htmlText.replaceFirst("<tableFirst>", "<table>");

      try (OutputStream out = response.getOutputStream()) {

         String fileName = name+ "_" + DateUtils.getNow("yyyyMMddHHmmss");

//       fileName = new String(fileName.getBytes(),"utf-8")+ ".xls";

         if ("large".equals(htmlText)) {

            ReportingPo report = reportingService.getByUid(uid);

            Map<String, Object> formParameters = generationService.getFormParameters(request.getParameterMap(), 

report.getDataRange());

            ReportTable reportTable = generationService.getReportTable(report, formParameters);

            htmlText = reportTable.getHtmlText();

         }

//       response.reset();

         response.addHeader("Content-Disposition", "attachment;filename=" +

 new String(fileName.getBytes("utf-8"),"iso-8859-1")+ ".xls");

//       response.setHeader("Content-Disposition", String.format("attachment; filename=%s", fileName));

         response.setContentType("application/vnd.ms-excel; charset=utf-8");

         response.setCharacterEncoding("utf-8");

         response.addCookie(new Cookie("fileDownload", "true"));

//       out.write(new byte[] { (byte) 0xEF, (byte) 0xBB, (byte) 0xBF }); // 生成带bom的utf8文件

         out.write(htmlText.getBytes("utf-8"));

         out.flush();

      } catch (Exception ex) {

         throw new RuntimeException(ex);

      }

   }

1

new String(fileName.getBytes("utf-8"),"iso-8859-1")+ ".xls"