java用模板导出数据表格

痛定思痛。 2023-06-27 11:19 30阅读 0赞

1.创建表格；

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2h1eGlhbmdlbg_size_16_color_FFFFFF_t_70][]

2.编写导出的controller;

@PostMapping("/cust/report/customer/export")
    public void export(HttpServletRequest request, HttpServletResponse response) {
    	List<Customer> custList = customerService.findAllCustomer();
    		OutputStream out = null;
    		BufferedOutputStream bos = null;
    		try {
    			String fileName = "【客户统计报表】" + DateUtil.currentData() + ".xlsx";
    			response.setContentType("multipart/form-data");
    			response.setHeader("Content-disposition",
    					"attachment; filename=" + new String(fileName.getBytes("UTF-8"), "ISO-8859-1"));
    			out = response.getOutputStream();
    			bos = new BufferedOutputStream(out);
    			String templateFileName = CustomerController.class.getResource("/template/excel/customer.xlsx").getFile();
    			ExcelWriter excelWriter = EasyExcel.write(bos).withTemplate(templateFileName).build();
    			// 数据回填
    			WriteSheet writeSheet = EasyExcel.writerSheet().build();
    			excelWriter.fill(custList.getData(), writeSheet);
    			Map<String, String> map = new HashMap<String, String>();
    			map.put("exportDate", new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(new Date()));
    			map.put("exportEmp", "导出人");
    			excelWriter.fill(map, writeSheet);
    			excelWriter.finish();
    			bos.flush();
    		} catch (Exception e) {
    			log.error("客户统计报表导出异常......{}", e);
    		} finally {
    			if (null != bos) {
    				try {
    					bos.close();
    				} catch (IOException e) {
    					e.printStackTrace();
    				}
    			}
    		}	
    }

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2h1eGlhbmdlbg_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/20200106142337800.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2h1eGlhbmdlbg==,size_16,color_FFFFFF,t_70