Home > Article > Web Front-end > js implements exporting Excel code
js implements exporting Excel code
- 小云云Original
- 2018-03-28 16:09:171792browse
本文主要和大家分享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!
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：js form validation implementation codeNext article：js form validation implementation code
Related articles
See more- An in-depth analysis of the Bootstrap list group component
- Detailed explanation of JavaScript function currying
- Complete example of JS password generation and strength detection (with demo source code download)
- Angularjs integrates WeChat UI (weui)
- How to quickly switch between Traditional Chinese and Simplified Chinese with JavaScript and the trick for websites to support switching between Simplified and Traditional Chinese_javascript skills