java填写xls模板_Java 新建excle文件并填充模版内容

//filename= P_gp_hs08.xlsx//判断文件是否存在，存在则追加，否则新增

File file = new File(filepath+"/"+filename);if (!file.exists() || !file.isFile()) {//logger.info("excle模板不存在，新增");

XSSFWorkbook wb = newXSSFWorkbook();

XSSFSheet sheetFlow= wb.createSheet("flow");

XSSFRow rowFlow0= sheetFlow.createRow(0);

XSSFCell cellFlow0Flow= rowFlow0.createCell(0);

cellFlow0Flow.setCellValue("flow名称");

XSSFCell cellFlow0Remark= rowFlow0.createCell(1);

cellFlow0Remark.setCellValue("备注");

XSSFRow rowFlow1= sheetFlow.createRow(1);

XSSFCell cellFlow1Folw= rowFlow1.createCell(0);

cellFlow1Folw.setCellValue("F_gp_"+list.get(0).getSysName());

XSSFSheet sheetGroup= wb.createSheet("group");

XSSFRow rowGroup0= sheetGroup.createRow(0);

XSSFCell cellGroup0Flow= rowGroup0.createCell(0);

cellGroup0Flow.setCellValue("flow名称");

XSSFCell cellGroup0Group= rowGroup0.createCell(1);

cellGroup0Group.setCellValue("group名称");

XSSFCell cellGroup0Remark= rowGroup0.createCell(2);

cellGroup0Remark.setCellValue("备注");

XSSFCell cellGroup0Relation= rowGroup0.createCell(2);

cellGroup0Relation.setCellValue("依赖");

XSSFSheet sheetJob= wb.createSheet("job");

XSSFRow rowJob0= sheetJob.createRow(0);

XSSFCell cellJob0= rowJob0.createCell(0);

cellJob0.setCellValue("flow名称");

XSSFCell cellJob1= rowJob0.createCell(1);

cellJob1.setCellValue("group名称");

XSSFCell cellJob2= rowJob0.createCell(2);

cellJob2.setCellValue("job名称");

XSSFCell cellJob3= rowJob0.createCell(3);

cellJob3.setCellValue("备注");

XSSFCell cellJob4= rowJob0.createCell(4);

cellJob4.setCellValue("依赖");

XSSFCell cellJob5= rowJob0.createCell(5);

cellJob5.setCellValue("类型");

XSSFCell cellJob6= rowJob0.createCell(6);

cellJob6.setCellValue("命令");

XSSFCell cellJob7= rowJob0.createCell(7);

cellJob7.setCellValue("参数变量");

XSSFCell cellJob8= rowJob0.createCell(8);

cellJob8.setCellValue("重试次数");

XSSFCell cellJob9= rowJob0.createCell(9);

cellJob9.setCellValue("重试间隔");

XSSFCell cellJob10= rowJob0.createCell(10);

cellJob10.setCellValue("超时时间");

FileOutputStream output;try{

output= new FileOutputStream(filepath+"/"+filename);

wb.write(output);

output.flush();

output.close();

}catch(Exception e) {//TODO Auto-generated catch block

e.printStackTrace();

logger.info("excle模板创建异常："+e.toString());

}

}