转载：excel出力

public void toexcel(HashMap hashmap,HttpServletRequest request,HttpServletResponse response) throws Exception{
String par=request.getParameter("cloumn");
String[] pars=par.split(",");
int filei=0;
String fileName = System.getProperty("java.io.tmpdir")+"\\xls"+(new java.util.Date().getTime())+(filei++);
jxl.write.WritableWorkbook wwb = Workbook.createWorkbook(new File(fileName));
jxl.write.WritableSheet ws = wwb.createSheet("Sheet 1", 0);//sheet1是导出excel分页第1页
for(int i=0;i<pars.length;i++){
ws.addCell(new jxl.write.Label(i, 0, pars[i]));//导出后excel中的字段名称,i是列,第一行
ws.setColumnView(i, 20);
}
QfcxActionDao qfcxdao=new QfcxActionDao();
List list=qfcxdao.creatitems(hashmap,request);
int j=1;
for(int i=0;i<list.size();i++){
QfcxActionPo qfcxactionpo=(QfcxActionPo)list.get(i);
int h=0;
for(int k=0;k<pars.length;k++){
if(pars[k].equals("抄表号")){//判断那些数据需要导出
ws.addCell(new jxl.write.Label(h,j,qfcxactionpo.getChaobiaohao()));
}
else if(pars[k].equals("用户号")){
ws.addCell(new jxl.write.Label(h,j,qfcxactionpo.getYonghuhao()));
}
else if(pars[k].equals("用户名称")){
ws.addCell(new jxl.write.Label(h,j,qfcxactionpo.getUsername()));
}
else if(pars[k].equals("装裱地址")){
ws.addCell(new jxl.write.Label(h,j,qfcxactionpo.getZhuangbiaodizhi()));
}
else if(pars[k].equals("表身号")){
ws.addCell(new jxl.write.Label(h,j,qfcxactionpo.getBiaoshenghao()));
}
else if(pars[k].equals("收费方式")){
ws.addCell(new jxl.write.Label(h,j,qfcxactionpo.getShoufeifangshi()));
}
else if(pars[k].equals("收费周期")){
ws.addCell(new jxl.write.Label(h,j,qfcxactionpo.getShoufeizhouqi()));
}
else if(pars[k].equals("用户状态")){
ws.addCell(new jxl.write.Label(h,j,qfcxactionpo.getUserstate()));
}
else if(pars[k].equals("生成日期")){
ws.addCell(new jxl.write.Label(h,j,qfcxactionpo.getShengchengriqi()));
}
else if(pars[k].equals("欠费金额")){
ws.addCell(new jxl.write.Label(h,j,qfcxactionpo.getQianfeijine().toString()));
}
else if(pars[k].equals("水量")){
ws.addCell(new jxl.write.Label(h,j,qfcxactionpo.getShuiliang().toString()));
}
else if(pars[k].equals("期数")){
ws.addCell(new jxl.write.Label(h,j,qfcxactionpo.getQishu().toString()));
}
else if(pars[k].equals("联系人")){
ws.addCell(new jxl.write.Label(h,j,qfcxactionpo.getLinkman()));
}
else if(pars[k].equals("联系电话")){
ws.addCell(new jxl.write.Label(h,j,qfcxactionpo.getLinkphonto()));
}
else if(pars[k].equals("移动电话")){
ws.addCell(new jxl.write.Label(h,j,qfcxactionpo.getLinkmanmobil()));
}
h++;
}
j++;
}
wwb.write();
wwb.close();
response.reset();

response.setContentType("application/x-msdownload;charset=GBK"); //设置响应类型为下载
response.setCharacterEncoding("UTF-8");
String docName=java.net.URLEncoder.encode("欠费用户信息.xls","UTF-8");
response.setHeader("Content-Disposition", "attachment; filename=" +new String(docName.getBytes("UTF-8"),"GBK"));
BufferedInputStream br = new BufferedInputStream(new FileInputStream(fileName));
byte[] buf = new byte[1024];
int len = 0;
OutputStream out = response.getOutputStream();
while((len = br.read(buf)) >0)
out.write(buf,0,len);
out.close();
br.close();
}