问zip文件中的Excel下载

EN

@ResponseBody
@RequestMapping(value = "/excelDownload", method = {RequestMethod.GET, RequestMethod.POST})
public ResponseEntity<Resource> excelDownload() throws Exception {
    ResponseEntity<byte[]> entity = null;
    ResponseEntity<Resource> excelFile = null;
    try {
        HashMap<String, String> param = new HashMap<String, String>();
        param = (HashMap<String, String>) session.getAttribute("mySession");

        List<BranchInfoDTO> BranchInfoDTOList = new ArrayList<>();
        try {
            BranchInfoDTOList = shopInfoService.selectMyListExcelDownload(param);
        } catch (Exception e) {
            e.printStackTrace();
        }

        List<List<String>> dataList = getDownloadData(BranchInfoDTOList);
        // the dataList part has no problem at the moment

        String folderName = getSessionUser().getName() + DateUtil.date2String(new Date(), DateUtil.YYYYMMDD_HHMMSS);
        String baseDirPath = tempDirPath + File.separator + folderName;
        InputStreamResource file = new InputStreamResource(ExcelHelper.downloadToExcel2(dataList)); // ExcelHelper.java will be seen below 

        excelFile = ResponseEntity.ok()
                .header(HttpHeaders.CONTENT_DISPOSITION, "attachment; filename=" + folderName + ".xlsx")
                .contentType(MediaType.parseMediaType("application/vnd.ms-excel"))
                .body(file);

    } catch (Exception e) {
        System.out.print(e);
        throw e;
    }
    return excelFile;
}

public static ByteArrayInputStream downloadToExcel2(List<List<String>> dataList) {
    try {
        ByteArrayOutputStream out = new ByteArrayOutputStream();

        InputStream resourceAsStream = new FileInputStream(PROXY_FORMAT_LOCAL);
        Workbook workBook = new XSSFWorkbook(resourceAsStream);
        Sheet sheet = workBook.getSheetAt(0);

        // Data
        int rowIdx = 1;
        for (List<String> stringList : dataList) {
            Row row = sheet.createRow(rowIdx++);
            System.out.println("row = " + row);

            for (int i = 0; i < stringList.size(); i++) {
                row.createCell(i).setCellValue(stringList.get(i));
            }
        }
        workBook.write(out);
        return new ByteArrayInputStream(out.toByteArray());
    } catch (IOException e) {
        throw new RuntimeException("fail to import data to Excel file: " + e.getMessage());
    }
}

ResponseEntity<byte[]> entity = ExcelFileInsideZip(excelFile);
return entity;