jsp 将数据导入 excel 保存到本地

public voidwriteToxls() throws Exception { request = ServletActionContext.getRequest();response = ServletActionContext.getResponse();String orderType = java.net.URLDecoder.decode(request.getParameter("orderType"), "UTF-8");String regionName =java.net.URLDecoder.decode(request.getParameter("regionName"), "UTF-8");String startDate = request.getParameter("startDate");String endDate = request.getParameter("endDate");StringBuffer whereSql = new StringBuffer(" where 1=1 ");StringBuffer selectSql = new StringBuffer("select flow_name, count(*) count from t_form_info"); List unfinished = jdbcTemplate.queryForList(stateSql);List allcount = jdbcTemplate.queryForList(allstateSql); String flowname ="工单未完成率";String fileName = flowname + ".xls";fileName = new String(fileName.getBytes(), "iso8859-1");// 解决中文response.setHeader("content-disposition", "attachment; filename=" + fileName);// 设定输出文件头response.setContentType("application/msexcel");// 定义输出类型OutputStream os = response.getOutputStream();WritableWorkbook wwb = Workbook.createWorkbook(os);jxl.write.WritableSheet ws = wwb.createSheet(flowname, 0);jxl.write.WritableFont wf = new jxl.write.WritableFont(WritableFont.ARIAL, 10, WritableFont.BOLD, true);jxl.write.WritableCellFormat wcfF = new jxl.write.WritableCellFormat(wf);jxl.write.Label labelCity = new jxl.write.Label(0, 0, "所属地市", wcfF);ws.addCell(labelCity);jxl.write.Label labelflowtype = new jxl.write.Label(1, 0, "工单类型", wcfF);ws.addCell(labelflowtype);jxl.write.Label labeltitle = new jxl.write.Label(2, 0, "未完成工单总数", wcfF);ws.addCell(labeltitle);jxl.write.Label labelflowno = new jxl.write.Label(3, 0, "工单总数", wcfF);ws.addCell(labelflowno);jxl.write.Label labelapplyperson = new jxl.write.Label(4, 0, "未完成率", wcfF);ws.addCell(labelapplyperson); for (int i = 1; i <= unfinished.size(); i++) {Map resultMap = (Map) unfinished.get(i);String flowName = resultMap.get("FLOW_NAME").toString();String count1 = resultMap.get("count").toString();Map resultMap1 = (Map) allcount.get(i);String count2 = resultMap1.get("count").toString();int rate = Integer.parseInt(count1) / Integer.parseInt(count2);Label city = new Label(0, i, regionName);ws.addCell(city);Label type = new Label(1, i, flowName);ws.addCell(type);Label no = new Label(2, i, count1);ws.addCell(no);Label title = new Label(3, i, count2);ws.addCell(title);Label ratee = new Label(4, i, rate + "");ws.addCell(ratee);}// 写入 Exel 工作表wwb.write();// 关闭 Excel 工作薄对象wwb.close();os.close();}