wsheet.setColumnView(8, 20); // 设置列的宽度
wsheet.setColumnView(9, 20); // 设置列的宽度
// 开始生成主体内容
wsheet.addCell(new Label(0, 1, "序号",wcfFC));
wsheet.addCell(new Label(1, 1, "日期",wcfFC));
wsheet.addCell(new Label(2, 1, "发文编号",wcfFC));
wsheet.addCell(new Label(3, 1, "收文单位",wcfFC));
wsheet.addCell(new Label(4, 1, "文件类型",wcfFC));
wsheet.addCell(new Label(5, 1, "件数",wcfFC));
wsheet.addCell(new Label(6, 1, "附件",wcfFC));
wsheet.addCell(new Label(7, 1, "文件标题",wcfFC));
wsheet.addCell(new Label(8, 1, "存档编号",wcfFC));
wsheet.addCell(new Label(9, 1, "签字",wcfFC));
wfont = new jxl.write.WritableFont(WritableFont.createFont("宋体"), 13,WritableFont.NO_BOLD, false, UnderlineStyle.NO_UNDERLINE,Colour.BLACK);
wcfFC = new WritableCellFormat(wfont);
wcfFC.setBorder(Border.NONE,BorderLineStyle.NONE);
int j = 2;
for (int i = 0; i < list.size(); i++) {
dispatch=(TblKepuoaRecordDispatch) list.get(i);
String uptime="";
if(dispatch.getDispatchDate()!=null&&!"".equals(dispatch.getDispatchDate())){
uptime=sdf2.format(dispatch.getDispatchDate());//时间格式化
}
wsheet.addCell(new Label(0, j, i+1+"",wcfFC));
wsheet.addCell(new Label(1, j,uptime,wcfFC));
wsheet.addCell(new Label(2, j,dispatch.getDispatchNo(),wcfFC));
wsheet.addCell(new Label(3, j,dispatch.getDispatchOrgan(),wcfFC));
/*if(dispatch!=null && dispatch.getDispatchOpreator()!=null && !"".equals(dispatch.getDispatchOpreator())){
if(dispatch.getCode()!=null && !"".equals(dispatch.getCode())){
}else{
wsheet.addCell(new Label(4, j,dispatch.getDispatchOpreator(),wcfFC));
}
}*/
wsheet.addCell(new Label(4, j, dispatch.getDispatchType(),wcfFC));
wsheet.addCell(new Label(5, j,String.valueOf(dispatch.getDispatchCount()),wcfFC));
wsheet.addCell(new Label(6, j,String.valueOf(dispatch.getDispatchAccessoriescCount()),wcfFC));
wsheet.addCell(new Label(7, j,dispatch.getDispatchName(),wcfFC));
wsheet.addCell(new Label(8, j, dispatch.getArchiveNo(),wcfFC));
j++;
}
} catch (IOException e) {
// TODO Auto-generated catch block
Loggers.info("DispatchAction 中 createExcel 方法："+e.getMessage());
e.printStackTrace();
}finally{
if(wbook != null){
wbook.write(); // 写入文件
wbook.close();
}
}
// 主体内容生成结束
return filename+".xls";
}
下面是参考jxl api里那个例子写的，把我自己觉得常用的excel操作基本都包含了：
[java]
package test;
import java.io.File;
i