//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("參數(shù)變量");

XSSFCell cellJob8= rowJob0.createCell(8);

cellJob8.setCellValue("重試次數(shù)");

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模板創(chuàng)建異常："+e.toString());

}

}

總結(jié)

以上是生活随笔為你收集整理的java填写xls模板_Java 新建excle文件并填充模版内容的全部內(nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯，歡迎將生活随笔推薦給好友。