java 代码
java 代码
- import jxl.Workbook;
- import jxl.write.Label;
- import jxl.write.WritableSheet;
- import jxl.write.WritableWorkbook;
- import jxl.write.WriteException;
- import jxl.write.biff.RowsExceededException;
jxl 包
java 代码
- try {
- SimpleDateFormat sdf = new SimpleDateFormat("yyyyMMddHHmmss");
- String fileName = "d:\\" + sdf.format(new Date()) + ".xls";
- WritableWorkbook book = Workbook.createWorkbook(new File(fileName));
- // -- 第一个参数是Sheet名,第二个参数是Sheet下标
- // -- 下标是整数,只起标识作用,建立的时候会以create顺序建立,本例生成的EXCEL文件第一个Sheet是sheet1
- WritableSheet sheet1 = book.createSheet("第一页",100000);
- WritableSheet sheet2 = book.createSheet("第二页",4);
- // -- 参数:先定位列,再定位行,再表格内容
- Label labTitle1 = new Label(0,0,"姓名");
- Label labTitle2 = new Label(1,0,"性别");
- Label labTitle3 = new Label(2,0,"移动电话");
- Label labTitle4 = new Label(3,0,"固定电话");
- Label labTitle5 = new Label(4,0,"家庭电话");
- sheet2.addCell(labTitle1);
- sheet2.addCell(labTitle2);
- sheet2.addCell(labTitle3);
- sheet2.addCell(labTitle4);
- sheet2.addCell(labTitle5);
- for(int i=1;i<3;i++) {
- Label lab1 = new Label(0,i,"老师");
- Label lab2 = new Label(1,i,"老师2");
- sheet2.addCell(lab1);
- sheet2.addCell(lab2);
- }
- book.write();
- book.close();
- } catch (IOException e) {
- e.printStackTrace();
- } catch (RowsExceededException e) {
- e.printStackTrace();
- } catch (WriteException e) {
- e.printStackTrace();
- }
姓名 | 性别 | 移动电话 | 固定电话 | 家庭电话 |
老师 | 老师2 | |||
老师 | 老师2 |