public ActionForward expResultForExcel(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) { String user_dm = authenticator.getUserDM(request.getSession()); String actid = request.getParameter("actid") != null ? request.getParameter("actid") : ""; String sid = sort.getSchool_id(user_dm); List list = sort.getSortInfoForExcel(actid); try { File file=new File(System.currentTimeMillis()+".xls"); WritableWorkbook wwb = Workbook.createWorkbook(file); //此处建立路径 jxl.write.WritableSheet ws = wwb.createSheet("Sheet1", 0); //建立工作簿 for (int i = 0; i < list.size(); i++) { //代表行 Map map=(Map)list.get(i); Set set=map.keySet(); Iterator iterator = set.iterator(); int j = 0; //j代表列 while (iterator.hasNext()) { Object test = (Object) iterator.next(); String str=""; try{ str=map.get(test).toString(); }catch(Exception e){ } jxl.write.Label label1 = new jxl.write.Label(j, i, str); //建立第一列 ws.addCell(label1); //放入工作簿 j++; } } //写入Exel工作表 wwb.write(); //关闭Excel工作薄对象 wwb.close(); response.setHeader("Content-disposition","attachment; filename=result.xls"); response.setContentType("application/msexcel"); InputStream in=new FileInputStream(file); OutputStream out=response.getOutputStream();
int bytesRead = 0; byte[] buffer = new byte[8192]; //设置缓冲大小 while ((bytesRead = in.read(buffer, 0, 8192)) != -1) { out.write(buffer, 0, bytesRead); } out.close(); file.delete(); return null; } catch (Exception e) { e.printStackTrace(); return null; } }
