java基于模板导出Excel表格

package com.example.exportdemo.controller; import com.example.exportdemo.domain.StoreInfo; import com.example.exportdemo.utils.EasyExportUtil; import org.springframework.stereotype.Controller; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.ResponseBody; import javax.servlet.http.HttpServletResponse; import java.io.FileInputStream; import java.io.FileNotFoundException; import java.io.IOException; import java.text.SimpleDateFormat; import java.util.*; /** * @author chenpeng * @date 2022/9/14 */ @Controller @RequestMapping(value="/store") public class StoreController { @RequestMapping(value="/exportStoreList") @ResponseBody public Object exportStoreSignList(HttpServletResponse response) throws Exception{ //随机生成文件名称 SimpleDateFormat simpleDate = new SimpleDateFormat("yyyyMMdd"); Date date = new Date(); String str = simpleDate.format(date); Random rand = new Random(); int rannum = (int) (rand.nextDouble()*(99999-10000+1)+10000); String fileName =str+rannum+".xlsx"; //服务器 // String localFilePath = ((ServletRequestAttributes)RequestContextHolder.getRequestAttributes()).getRequest().getSession().getServletContext() // .getRealPath("//downloadFiles"); //本地 String localFilePath = "d:\\"; //获取模板路径 String templatePath = this.getClass().getClassLoader().getResource("templates/store_template.xlsx").getPath(); List<StoreInfo> storeList = new ArrayList<>(); StoreInfo storeInfo = new StoreInfo(); storeInfo.setCardNum("321321199905071209"); storeInfo.setCardType("身份证"); storeInfo.setInReason("测试"); storeInfo.setInTime(date); storeInfo.setOrgName("百度"); storeInfo.setUserName("小王"); storeList.add(storeInfo); EasyExportUtil.exportExcelByTemplate(localFilePath+fileName, templatePath, storeList); response.setCharacterEncoding("utf-8"); //返回的数据类型 response.setContentType("application/vnd.ms-excel;charset=utf-8"); //响应头 response.setHeader("Content-Disposition", "attachment;fileName=" + fileName); FileInputStream fis = null; try { fis = new FileInputStream(localFilePath+"//"+fileName); byte[] data = new byte[fis.available()]; fis.read(data); response.getOutputStream().write(data); } catch (FileNotFoundException e) { e.printStackTrace(); } catch (IOException e) { e.printStackTrace(); }finally { //关闭输入输出流 if(fis!=null) { fis.close(); } } return null; } }