excel导出jqvq代码.doc

/** * 试卷整体情况统计 excel导出 * @param request * @throws IOException * @throws WriteException */ public void sjztqktjExcel(HttpServletRequest request) throws IOException, WriteException { sjfxEntity entity=new sjfxEntity(); HttpSession session = request.getSession(true); String ksq=String.valueOf(request.getParameter(ksq));//考试期 String zydm=String.valueOf(request.getParameter(zydm));//专业 String kcdm=String.valueOf(request.getParameter(kcdm));//课程 String qxdm=String.valueOf(request.getParameter(qxdm));//区县 String zxzzdm=String.valueOf(request.getParameter(zxzzdm));//助学单位 String jtdwdm=String.valueOf(request.getParameter(jtdwdm));//集体单位 String kslbdm = (String)request.getSession().getAttribute(kslbdm); String cd = String.valueOf(request.getParameter(cd));//菜单名 boolean ifpage=false; List list = entity.selectSjztqktj(ksq, zydm, kcdm, qxdm,zxzzdm, jtdwdm, kslbdm,request,ifpage); String title = 高等教育自学考试试卷整体情况统计表; String filename = 高等教育自学考试试卷整体情况统计表; title += (+ksq+); filename += _+ksq+.xls; //文件路径 String filepath = request.getRealPath(/) + download\\excel\\jsxkhzb\\; File file = new File(filepath); filepath = filepath + filename; if (!file.exists()) { file.mkdirs(); } WritableWorkbook workbook = Workbook.createWorkbook(new File(filepath)); try { WritableSheet sheet = workbook.createSheet(cd, 0); sheet.setPageSetup(PageOrientation.PORTRAIT,PaperSize.A4,0,0); sheet.getSettings().setLeftMargin(0.5); sheet.getSettings().setRightMargin(0.5); WritableCellFormat style = null; style = new WritableCellFormat(); style.setAlignment(Alignment.CENTRE); style.setVerticalAlignment(VerticalAlignment.CENTRE); style.setBorder(Border.ALL, BorderLineStyle.THIN); style.setBackground(Colour.WHITE); style.setWrap(true); WritableCellFormat style_t = null; WritableFont font_t = null; font_t = new WritableFont(WritableFont.ARIAL, 14, WritableFont.BOLD, f