poi多sheet，模板导出数据

模板导出数据"/>

poi多sheet，模板导出数据

/*** 导出Excel* @param response 响应对象* @param headName 表头* @param  List     数据*/public static void exportExcel(HttpServletResponse response, String headName, List<数据对象> list) throws IOException {//读取模板Resource resource=new ClassPathResource("file/模板.xlsx");Workbook workbook=new XSSFWorkbook(resource.getInputStream());//设置数据剧中CellStyle cellStyle = workbook.createCellStyle();cellStyle.setAlignment(HorizontalAlignment.CENTER);cellStyle.setVerticalAlignment(VerticalAlignment.CENTER);//获得 sheetSheet sheet= workbook.getSheetAt(0);//获得第一行 设置表头内容Row headRow = sheet.getRow(0);Cell headRowCell = headRow.getCell(0);headRowCell.setCellValue(headName);//从第表格第三行开始写入数据，根据模板设置index开始的值int index=2;Cell cell=null;for (XXX xxx : list) {//创建行Row rowData = sheet.createRow(index++);/创建cell 写入值cell=rowData.createCell(0);cell.setCellStyle(cellStyle);cell.setCellValue(xxx.getXXX());cell=rowData.createCell(1);cell.setCellStyle(cellStyle);cell.setCellValue(xxx.getXXX());...}//如果是多数据源 导出 多个sheet  //获得 第二个 sheetSheet sheet2= workbook.getSheetAt(1);//此处写法不一样String fileName = URLEncoder.encode("表格名称", "utf-8");response.setContentType("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");response.setCharacterEncoding("utf-8");fileName = URLEncoder.encode(fileName, "UTF-8").replaceAll("\\+", "%20");response.setHeader("Content-disposition", "attachment;filename=" + fileName + ".xlsx");workbook.write(response.getOutputStream());//String fileName = URLEncoder.encode("表格名称.xlsx", "utf-8");//response.setHeader("content-type", "application/octet-stream;charset=utf-8");//response.setHeader("content-disposition", "attachment; ");//response.setHeader("filename",fileName);//workbook.write(response.getOutputStream());}