JXL了解

1.JAVA转EXCEL:首先需要jxl.jar,得到文件路径:File file = new File(fullFileName);
2.WritableWorkbook ww = Workbook.createWorkbook(file, wb); //构建WorkBook对象 WritableSheet ws =  wwb.getSheet(res.getString("AAA"));//创建工作表 //如果系统是EXCEL2007可能发生异常,此时要处理一下:
if (wb != null){OutputStream os = new FileOutputStream(file);ww = Workbook.createWorkbook(os);ws = wwb.getSheet(res.getString("AAA"));}
3.单元格格式对象WritableCellFormat cellFormat = new WritableCellFormat();
4.增加行ws.addCell(new Label(i, J, "单元格内容", cellFormat));//I表示列,J表示行--标题行和普通行一样,可以格样式.
5.最后记得关闭ww,ws,os等对象