@TOC多页签报表导出

功能需求

每个部门每月都会发起“办公用品申请及领用流程”，经行政负责人审批后的流程，系统可统计本月内所有已审批的流程，自动将办公用品明细汇总成excel表。

具体实现效果

第一个页签为汇总表，记录该月的所有办公用品的申报信息：多页签报表导出
接下来的页签为各部门申请办公用品的明细，页签命名为部门+(流程名)

效果展示

jsp页面：
多页签报表导出
导出效果：

界面展示：

代码实现

界面的编写

<%@ page language="java" contentType="text/html; charset=UTF-8"
	pageEncoding="UTF-8"%>
<%@ include file="/sys/ui/jsp/common.jsp"%>
<template:include ref="default.simple">
	<template:replace name="body">
		<%@ page import="java.util.*"%>
		<%@ page import="com.landray.kmss.km.oitems.model.KmOitemsListing"%>
		<%@ page
			import="com.landray.kmss.km.oitems.model.KmOitemsShoppingTrolley"%>
		<%@ page import="org.apache.commons.lang.StringEscapeUtils"%>
		<script type="text/javascript">
			seajs.use([ 'theme!form' ]);
		</script>
		<script type="text/javascript">
			Com_IncludeFile("docutil.js|calendar.js|dialog.js|doclist.js|optbar.js|list.js");
		</script>
		<script type="text/javascript">
			Com_AddEventListener(document, "keydown", function() {
				var eventObj = Com_GetEventObject();
				var keyCode = eventObj.keyCode;
				if (keyCode == 13) {
					var clickObj = document.getElementById("ok_id");
					clickObj.click();
				}
			});

			seajs.use([ 'lui/dialog' ], function(dialog) {
				window.dialog = dialog;
			});

			function clear_data() {
				alert(1);
				location.href = "${LUI_ContextPath }/km/oitems/km_oitems_listing/kmOitemsListing.do?method=outCount";
			}
			window.onload = function() {
				setTimeout(dyniFrameSize, 100);
			};
			function dyniFrameSize() {
				try {
					// 调整高度
					var arguObj = document.getElementById("contentDiv");
					if (arguObj != null && window.frameElement != null
							&& window.frameElement.tagName == "IFRAME") {
						window.frameElement.style.height = (arguObj.offsetHeight + 40)
								+ "px";
					}
				} catch (e) {
				}
			};
		</script>


		<script type="text/javascript">
			$(function() {
				var dd = new Date();
				var currentYear = dd.getFullYear();
				var size = currentYear - 2002 + 1;
				for (var i = 0; i < size; i++) {
					var yearOld = currentYear - i;
					$("#years").append(
							$("<option value="+yearOld+">" + yearOld + "年"
									+ "</option>"));
				}
			});
			var textSel = null;
			/* 获取选中的下拉框的值 */
			function yearSelected() {
				textSel = $("#years").find("option:selected").val();

			}

			/* 获取选中月份的下拉框的值 */
			var monthText = null;
			function show() {
				monthText = $("#select").find("option:selected").val();
			}
			
			function clear_data() {
				location.href = "${LUI_ContextPath }/km/oitems/km_oitems_listing/kmOitemsListing.do?method=export&years="+textSel+"&month="+monthText;
			}
		</script>
		<html:form action="/km/oitems/km_oitems_listing/kmOitemsListing.do">
			<ui:tabpanel id="kmOitemsOutCountPanel" layout="sys.ui.tabpanel.list">
				<ui:content id="kmOitemsOutCountContent"
					title="${ lfn:message('km-oitems:kmOitems.tree.reporting2') }">
					<div id="contentDiv"
						style="width: 95%; min-height: 500px; padding: 20px">
						
						<center>
							<div style="width: 96%; padding-top: 35px">
								<table width="70%" class="tb_normal">
									<tr>
										<td class="td_normal_title" width="15%">年份</td>
										<td><select id="years" name="years"
											onchange="yearSelected()">
												<option value="-1">---请选择---</option>
										</select></td>

										<td class="td_normal_title" width="15%">月份</td>
										<td><select class="ui-select" name="select" id="select"
											onchange="show()">
												<option value="0">--请选择---</option>
												<option value="1">1月</option>
												<option value="2">2月</option>
												<option value="3">3月</option>
												<option value="4">4月</option>
												<option value="5">5月</option>
												<option value="6">6月</option>
												<option value="7">7月</option>
												<option value="8">8月</option>
												<option value="9">9月</option>
												<option value="10">10月</option>
												<option value="11">11月</option>
												<option value="12">12月</option>
										</select></td>
									</tr>
								</table>
							</div>
							<br /> <span> <ui:button id="ok_id" text="导出" order="2" onclick="clear_data();">
								</ui:button>&nbsp;&nbsp; <ui:button
									text="${lfn:message('km-oitems:kmOitems.button.clear') }"
									order="2" onclick="clear_data();">
								</ui:button>
							</span> <br /> <br />

							<div style="width: 96%"></div>
						</center>
					</div>
				</ui:content>
			</ui:tabpanel>
		</html:form>
		<script type="text/javascript">
			function onRadioClick(obj) {
				var a_deptObj = document.getElementById("a_dept_id");
				var a_personObj = document.getElementById("a_person_id");
				var value = obj.value;
				if (value == 1) {
					a_deptObj.style.display = "";
					a_personObj.style.display = "none";
				} else {
					a_deptObj.style.display = "none";
					a_personObj.style.display = "";
				}
			}
		</script>
	</template:replace>
</template:include>

后端代码的实现（action层的数据交互）

###导出方法

	/**
	 * 导出
	 */
	public ActionForward export(ActionMapping mapping, ActionForm form, HttpServletRequest request,HttpServletResponse response) throws Exception {
		String years = request.getParameter("years");//获取前端years的值
		String month = request.getParameter("month");//获取月份
		System.out.println("年:" + years);
		System.out.println("月:" + month);
		//调用导出方法
		HSSFWorkbook wb = listArticles(years,month); //将年月传入listArticles(years,month)创建excel表单
		String filename = years+"年"+month+"月"+"办公用品申请表";//excel表单的名字设定
		response.setContentType("application/vnd.ms-excel");
		filename = new String(filename.getBytes("GBK"), "iso8859-1")
				+ ".xls";
		response.setHeader("Cache-Control", "max-age=0");
		response.addHeader("Content-Disposition", "attachment;filename="+ filename);
        wb.write(response.getOutputStream());
		return getActionForward(null, mapping, form, request, response);
	}

注意：创建excel表单的文件后缀有两种(.xlsx和.xls)，生成这两种格式表单有对应不同的表单类，千万不要弄错！！

导出.xlsx格式

表单类用：

Workbook workbook = new XSSFWorkbook();

response设置：

 response.setContentType("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");
 response.addHeader("Content-Disposition", "attachment;filename=fileName" + ".xlsx");

导出.xls格式