jxl操作xls文档小结

JXL使用入门

JXL 操作xls文档

1 创建xls文件

//创建工作薄对象WritableWorkbook book = Workbook.createWorkbook(new File("1.xls"));  //创建工作表WritableSheet sheet = book.createSheet("test", 0); 

2 添加下拉列表

//添加下拉列表List angerlist = new ArrayList();   angerlist.add("是");   angerlist.add("否"); Label norFormat = null; norFormat = new Label(0, 0, "是"); WritableCellFeatures ws = new WritableCellFeatures(); ws.setDataValidationList(angerlist); norFormat.setCellFeatures(ws); sheet.addCell(norFormat);

3 添加公式

//添加公式String format="IF(A1=\"是\",1,2)";Formula formula = new Formula(0, 1, format);sheet.addCell(formula);

4 生成文档

book.write();book.close();