JXL导出

[size=medium]@SuppressWarnings("unchecked")
public int writeExcelBo(java.util.List ve){
HttpServletResponse response=ServletActionContext.getResponse();
jxl.write.WritableWorkbook wwb=null;
try{
OutputStream os = response.getOutputStream();// 取得输出流
response.reset();
response.setHeader("Content-disposition", "attachment; filename="+new String("采集".getBytes("GB2312"),"8859_1")+".xls");// 设定输出文件头
response.setContentType("application/msexcel");// 定义输出类型
wwb=Workbook.createWorkbook(os);
int SIZE=ve.size();//总数
jxl.write.WritableSheet ws=null;
News book=null;
ws=wwb.createSheet("第1页",1);
int k=1;//页数
int j=0;//每页循环次数
for (int i = 0; i <SIZE; i++) {//循环总数
if (i<Constant.excelcount) {
j=i;
}else{
if (i>0&&i%Constant.excelcount==0) {//是否建立新页面
k=k+1;//页数加1
ws=wwb.createSheet("第"+k+"页",k);
}
if (i>=Constant.excelcount*(k-1)) {
j=i-Constant.excelcount*(k-1);//重新开始循环
}

}
book=new News();
book=(News) ve.get(i);
ws.addCell(new jxl.write.Label(0,0,"序号"));
ws.addCell(new jxl.write.Label(1,0,"标题"));
ws.addCell(new jxl.write.Label(2,0,"发布时间"));
ws.addCell(new jxl.write.Label(3,0,"来源网站"));
ws.addCell(new jxl.write.Label(4,0,"采集时间"));
// ws.addCell(new jxl.write.Label(5,0,"集合位置"));
ws.addCell(new jxl.write.Label(0,j+1,Integer.toString(j+1)));
ws.addCell(new jxl.write.Label(1,j+1,book.getTitle()));
ws.addCell(new jxl.write.Label(2,j+1,book.getPubdate().toString().substring(0, 10)));
ws.addCell(new jxl.write.Label(3,j+1,book.getWebsitename()));
ws.addCell(new jxl.write.Label(4,j+1,book.getCollentTime().toString().substring(0, 19)));
// ws.addCell(new jxl.write.Label(5,j+1,String.valueOf(i)));
}

wwb.write();
wwb.close();
return 1;
}catch(IOException e){
}catch(RowsExceededException e){
}catch(WriteException e){
}
return 0;
}[/size]