public void excel(){
String[] titleA = {"id","student number","name"};
File fileA = new File("D:/TestFile.xls");
if(fileA.exists()){
fileA.delete();
}
try {
fileA.createNewFile();
WritableWorkbook workbookA = Workbook.createWorkbook(fileA);
WritableSheet sheetA = workbookA.createSheet("sheet1", 0);
Label labelA = null;
for (int i = 0; i < titleA.length; i++) {
labelA = new Label(i,0,titleA[i]);
sheetA.addCell(labelA);
}
for (int i = 1; i < 10; i++) {
labelA = new Label(0,i,i+" ");
sheetA.addCell(labelA);
labelA = new Label(1,i,"20000001" + i);
sheetA.addCell(labelA);
labelA = new Label(2,i,"学生00"+i);
sheetA.addCell(labelA);
}
workbookA.write();
workbookA.close();
logger.info("已往D盘写入文件,请前去查看");
} catch (Exception e) {
logger.info("写入失败");
}
}
Excel文件
最新推荐文章于 2024-08-12 19:45:53 发布