java 背景下載下傳Excel檔案

方法一：

/**
	 * @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();
    }