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();