FileOutputStream os = null;
WritableWorkbook wbook = null;
WritableSheet wsheet = null;
try {
os = new FileOutputStream(new File("D:\\wocao.xls"));
wbook = Workbook.createWorkbook(os); // 建立excel文件
wsheet = wbook.createSheet("学生信息表", 0); // 工作表名称
// 设置Excel字体
WritableFont wfont = new WritableFont(WritableFont.ARIAL, 16,
WritableFont.BOLD, false,
jxl.format.UnderlineStyle.NO_UNDERLINE,
jxl.format.Colour.BLACK);
WritableCellFormat titleFormat = new WritableCellFormat(wfont);
String[] title = { "姓名", "年龄", "专业", "其他" };
// 设置Excel表头
for (int i = 0; i < title.length; i++) {
Label excelTitle = new Label(i, 0, title[i], titleFormat);
wsheet.addCell(excelTitle);
}
int c = 1; // 用于循环时Excel的行号
Label content1 = new Label(0, c, "aaa");
Label content2 = new Label(1, c, "bbb");
Label content3 = new Label(2, c, "ccc");
Label content4 = new Label(3, c, "ddd");
wsheet.addCell(content1);
wsheet.addCell(content2);
wsheet.addCell(content3);
wsheet.addCell(content4);
wbook.write();
} catch (FileNotFoundException e) {
e.printStackTrace();
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (RowsExceededException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (WriteException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} finally {
try {
wbook.close();
os.close();
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} // 写入文件
catch (WriteException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}