本文主要和大家分享js实现导出Excel，主要以代码的形式和大家分享，希望能帮助到大家。
<%--
Created by IntelliJ IDEA.
User: Administrator
Date: 2017/7/10
Time: 13:39
To change this template use File | Settings | File Templates.
--%>
<%--按处室报表===--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%@ include file="/webpage/include/taglib.jsp" %>
<html>
<head>
<title>固定报表</title>
<meta name="decorator" content="default"/>
<script src="${ctxStatic}/excel/excellentexport.min.js"></script>
<script type="text/javascript">
$(document).ready(function() {
if(${fmOrgDurationDays.year==null}) {
$("#year").select2("val", 2017);
$("#year2").select2("val", 2017);
}
});
</script>
</head>
<body class="gray-bg">
<%--<include file="/webpage/demo/header.jsp" />--%>
<%--<link rel="import" href="/.../.../header.jsp>--%>
<p class="wrapper wrapper-content">
<p class="ibox">
<p class="ibox-title">
<h5>固定报表 </h5>
<p class="ibox-tools">
<a class="collapse-link">
<i class="fa fa-chevron-up"></i>
</a>
<a class="dropdown-toggle" data-toggle="dropdown" href="#">
<i class="fa fa-wrench"></i>
</a>
<ul class="dropdown-menu dropdown-user">
<li><a href="#">选项1</a>
</li>
<li><a href="#">选项2</a>
</li>
</ul>
<a class="close-link">
<i class="fa fa-times"></i>
</a>
</p>
</p>
<p class="ibox">
<p class="ibox-content">
<p class="tabs-container">
<p>
<table>
<form:form id="searchForm" modelAttribute="fmOrgDurationDays"
action="${ctx}/fixedreport/fmOrgDurationDays/" method="post"
class="form-inline">
<input id="pageNo" name="pageNo" type="hidden"
value="${page.pageNo}" />
<input id="pageSize" name="pageSize" type="hidden"
value="${page.pageSize}" />
<table:sortColumn id="orderBy" name="orderBy"
value="${page.orderBy}" callback="sortOrRefresh();" />
<!-- 支持排序 -->
<tr>
<td><span>开始年<span style="color:red">*</span>：
</span></td>
<td>
<%--<form:select id="year" path="year" class="form-control m-b"><form:option value="" label=""/><form:options items="${fm_years}" htmlEscape="false"/></form:select>--%>
<%--<%–<form:input path="year" htmlEscape="false" maxlength="4" class=" form-control input-sm"/>–%>--%>
<form:select id="year" path="year" class="form-control m-b"
style="width:120px">
<form:options items="${fns:getDictList('fm_years')}"
itemLabel="label" itemValue="value" htmlEscape="false" />
</form:select>
</td>
<td><span>月<span style="color:red">*</span>：
</span></td>
<td><form:select path="month" class="form-control m-b"
style="width:100px">
<form:options items="${fns:getDictList('fm_months')}"
itemLable="label" itemValue="value" htmlEscape="false" />
</form:select> <%-- <form:input path="month" htmlEscape="false" maxlength="2" class=" form-control input-sm"/>--%>
</p></td>
<td><span>结束年<span style="color:red">*</span>：
</span></td>
<td>
<%--<form:select id="year" path="year" class="form-control m-b"><form:option value="" label=""/><form:options items="${fm_years}" htmlEscape="false"/></form:select>--%>
<%--<%–<form:input path="year" htmlEscape="false" maxlength="4" class=" form-control input-sm"/>–%>--%>
<form:select id="year2" path="year2" class="form-control m-b"
style="width:120px">
<%--<form:option value="" label=""/>--%>
<form:options items="${fns:getDictList('fm_years')}"
itemLabel="label" itemValue="value" htmlEscape="false" />
</form:select>
</td>
<td><span>月<span style="color:red">*</span>：
</span></td>
<td><form:select path="month2" class="form-control m-b"
style="width:100px">
<form:options items="${fns:getDictList('fm_months')}"
itemLable="label" itemValue="value" htmlEscape="false" />
</form:select> <%-- <form:input path="month" htmlEscape="false" maxlength="2" class=" form-control input-sm"/>--%>
</p></td>
<td><span>时长类型<span style="color:red">*</span> ：
</span></td>
<td><form:select path="customDuration.durationType"
class="form-control m-b" style="width:170px">
<form:option value="" label="" />
<form:options items="${fns:getDictList('fm_flowtype')}"
itemLabel="label" itemValue="value" htmlEscape="false" />
</form:select></td>
<td><span>出入境：</span></td>
<td><form:select path="fmItfDclIoDecl.expImpFlag"
class="form-control m-b" style="width:100px">
<form:option value="" label="" />
<form:options items="${fns:getDictList('fm_eoiflag')}"
itemLabel="label" itemValue="value" htmlEscape="false" />
</form:select></td>
</tr>
</form:form>
</table>
</p>
<p class="row">
<p class="col-sm-12">
<p class="pull-right">
<button class="btn btn-primary btn-rounded btn-outline btn-sm " onclick="search()"><i
class="fa fa-search"></i> 查询
</button>
<button class="btn btn-primary btn-rounded btn-outline btn-sm " onclick="reset()"><i
class="fa fa-refresh"></i> 重置
</button>
<a download="固定报表-按处室.xls" href="#" onclick="return ExcellentExport.excel(this, 'contentTable1', '固定报表');"
class="btn btn-primary btn-rounded btn-outline btn-sm "><i class="fa fa-file-excel-o"></i>导出</a>
</p>
</p>
</p>
<p class="tab-content">
<p id="tab-1" class="tab-pane active">
<p style="width:100%;overflow-x:scroll" >
<table id="contentTable1"
class="table table-striped table-bordered table-hover table-condensed dataTables-example dataTable no-footer" style="width:2000px">
<thead>
<tr class="hidden">
<th style="text-align: center; font-size: large" colspan="${cu.size() * 3 + 2}">固定报表（按处室统计）</th>
</tr>
<tr class="hidden">
<th style="text-align: center" colspan="${cu.size() * 3 + 2}"> </th>
</tr>
<tr>
<th rowspan="2" style="width:100px">分支机构</th>
<th rowspan="2" style="width:100px">处室代码</th>
<c:forEach items="${cu}" var="bu">
<th colspan="3">${bu.durationName}</th>
</c:forEach>
</tr>
<tr>
<c:forEach items="${cu}" var="bu">
<th>时长（天）</th>
<th>同比%</th>
<th>批次</th>
</c:forEach>
</tr>
</thead>
<tbody>
<c:if test="${map!=null&&map.size()>0}">
<c:forEach items="${map}" var="fm">
<tr>
<td>${fm.NAME}</td>
<td>${fm.ORGCODE}</td>
<c:forEach items="${cu}" var="bu">
<td><fmt:formatNumber type="number" value="${fm.get(bu.durationCol.concat('Duration'))}" maxFractionDigits="2"/></td>
<td><fmt:formatNumber type="number" value="${fm.get(bu.durationCol.concat('DurationRate'))*100}" maxFractionDigits="2"/>%</td>
<td>${fm.get(bu.durationCol.concat("Batch"))}</td>
</c:forEach>
</tr>
</c:forEach>
<tr>
<td colspan="2" align="center">总平均</td>
<c:forEach items="${cu}" var="bu">
<td><fmt:formatNumber type="number" value="${zj.get(bu.durationCol.concat('Duration'))}" maxFractionDigits="2"/></td>
<td><fmt:formatNumber type="number" value="${zj.get(bu.durationCol.concat('DurationRate'))*100}" maxFractionDigits="2"/>%</td>
<td>${zj.get(bu.durationCol.concat("Batch"))}</td>
</c:forEach>
</tr>
</c:if>
<c:if test="${map1!=null&&map1.size()>0}">
<c:forEach items="${map1}" var="fm">
<tr>
<td>
<c:forEach items="${dname}" var="dna">
<c:if test="${dna.CODE==fm.ORGCODE}">
${dna.NAME}
</c:if>
</c:forEach>
</td>
<td>${fm.ORGCODE}</td>
<c:forEach items="${cu}" var="bu">
<td>${fm.get(bu.startTimeCol)}</td>
<td><fmt:formatNumber type="number" value="${fm.get(bu.startTimeCol.concat('Rate'))*100}" maxFractionDigits="2"/>%</td>
<td>${fm.get(bu.endTimeCol)}</td>
</c:forEach>
</tr>
</c:forEach>
<tr>
<td colspan="2" align="center">总平均</td>
<c:forEach items="${cu}" var="bu">
<td>${zj.get(bu.startTimeCol)}</td>
<td><fmt:formatNumber type="number" value="${zj.get(bu.startTimeCol.concat('Rate'))*100}" maxFractionDigits="2"/>%</td>
<td>${zj.get(bu.endTimeCol)}</td>
</c:forEach>
</tr>
</c:if>
</tbody>
</table>
</p>
</p>
</p>
</p>
</p>
</p>
</p>
</p>
</body>
</html>相关推荐：
The above is the detailed content of js implements exporting Excel code. For more information, please follow other related articles on the PHP Chinese website!
js method to get array length
js refresh current page
js rounding
Compare the similarities and differences between two columns of data in excel
excel duplicate item filter color
How to copy an Excel table to make it the same size as the original
Excel table slash divided into two
Excel diagonal header is divided into two
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
