js实现导出Excel代码
内容导读
互联网集市收集整理的这篇技术教程文章主要介绍了js实现导出Excel代码，小编现在分享给大家，供广大互联网技能从业者学习和参考。文章包含8035字，纯文字阅读大概需要12分钟。
内容图文
本文主要和大家分享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>相关推荐：
PHP创建或导出Excel数据表格的方法
以上就是js实现导出Excel代码的详细内容，更多请关注Gxl网其它相关文章！
内容总结
以上是互联网集市为您收集整理的js实现导出Excel代码全部内容，希望文章能够帮你解决js实现导出Excel代码所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错，欢迎将互联网集市网站推荐给程序员好友。
内容备注
版权声明：本文内容由互联网用户自发贡献，该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容， 请发送邮件至 gblab@vip.qq.com 举报，一经查实，本站将立刻删除。
内容手机端
扫描二维码推送至手机访问。
来源：【匿名】