java 后台下载Excel文件

我会带着你远行 2022-10-07 14:47 171阅读 0赞

方法一：

/**
    	 * @Title: WmsPoController
    	 * @Description: Excel模板下载
    	 * @author TimBrian
    	 * @since Jun 18, 2021 3:40:06 PM
    	 * @param response
    	 * @param map
    	 * @throws IOException
    	 */
    	@ApiOperation(value = "下载PO模板")
        @HibasePostRequestMapping(value = "linkPoTemplate")
    	public void linkPo(HttpServletResponse response, @RequestBody Map<String, String> map){
    		
    		String fileName = map.get("fileName");
    		HibaseAssert.isTrue(StrUtil.isNotEmpty(fileName), "fileName is Empty");
    		
    		ClassPathResource resource = new ClassPathResource("template/" + fileName);
    		
    		response.reset();
            response.setCharacterEncoding("UTF-8");
            response.setHeader("Content-disposition", "attachment;filename=" + fileName);
            response.setContentType("application/vnd.ms-excel;charset=utf-8");
            
    		try (HSSFWorkbook wb = new HSSFWorkbook(resource.getInputStream());
    				OutputStream os = response.getOutputStream();){
    		        wb.write(os);
    		} catch (IOException e) {
    			e.printStackTrace();
    			log.error("文件下载fail");
    		}
    	}

方法二：

/**
    	 * @Title: WmsPoController
    	 * @Description: Excel模板下载
    	 * @author TimBrian
    	 * @since Jun 18, 2021 3:40:06 PM
    	 * @param response
    	 * @param fileName
    	 */
    	@ApiOperation(value = "下载PO模板")
        @HibaseGetRequestMapping(value = "linkPoTemplate")
    	public Object linkPoTemplate(HttpServletResponse response, String fileName){
    
            ClassPathResource resource = new ClassPathResource("template/po_import_template.xls");
            String filename = resource.getFilename();
            try {
                HibaseAssert.notNull(filename, "获取文件名失败");
                return ResponseEntity.ok()
                        .contentType(MediaType.parseMediaType("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"))
                        .header(HttpHeaders.CONTENT_DISPOSITION,
                                "attachment; filename=\"" + URLEncoder.encode(filename, "UTF-8") + "\"")
                        .body(resource);
            } catch (UnsupportedEncodingException e) {
                e.printStackTrace();
            }
            return ResponseModel.successMsg();
        }