本文主要和大家分享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 id="固定报表-nbsp">固定报表 </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!
es6数组怎么去掉重复并且重新排序May 05, 2022 pm 07:08 PM去掉重复并排序的方法：1、使用“Array.from(new Set(arr))”或者“[…new Set(arr)]”语句，去掉数组中的重复元素，返回去重后的新数组；2、利用sort()对去重数组进行排序，语法“去重数组.sort()”。
JavaScript的Symbol类型、隐藏属性及全局注册表详解Jun 02, 2022 am 11:50 AM本篇文章给大家带来了关于JavaScript的相关知识，其中主要介绍了关于Symbol类型、隐藏属性及全局注册表的相关问题，包括了Symbol类型的描述、Symbol不会隐式转字符串等问题，下面一起来看一下，希望对大家有帮助。
原来利用纯CSS也能实现文字轮播与图片轮播！Jun 10, 2022 pm 01:00 PM怎么制作文字轮播与图片轮播？大家第一想到的是不是利用js，其实利用纯CSS也能实现文字轮播与图片轮播，下面来看看实现方法，希望对大家有所帮助！
JavaScript对象的构造函数和new操作符（实例详解）May 10, 2022 pm 06:16 PM本篇文章给大家带来了关于JavaScript的相关知识，其中主要介绍了关于对象的构造函数和new操作符，构造函数是所有对象的成员方法中，最早被调用的那个，下面一起来看一下吧，希望对大家有帮助。
JavaScript面向对象详细解析之属性描述符May 27, 2022 pm 05:29 PM本篇文章给大家带来了关于JavaScript的相关知识，其中主要介绍了关于面向对象的相关问题，包括了属性描述符、数据描述符、存取描述符等等内容，下面一起来看一下，希望对大家有帮助。
javascript怎么移除元素点击事件Apr 11, 2022 pm 04:51 PM方法：1、利用“点击元素对象.unbind("click");”方法，该方法可以移除被选元素的事件处理程序；2、利用“点击元素对象.off("click");”方法，该方法可以移除通过on()方法添加的事件处理程序。
整理总结JavaScript常见的BOM操作Jun 01, 2022 am 11:43 AM本篇文章给大家带来了关于JavaScript的相关知识，其中主要介绍了关于BOM操作的相关问题，包括了window对象的常见事件、JavaScript执行机制等等相关内容，下面一起来看一下，希望对大家有帮助。
foreach是es6里的吗May 05, 2022 pm 05:59 PMforeach不是es6的方法。foreach是es3中一个遍历数组的方法，可以调用数组的每个元素，并将元素传给回调函数进行处理，语法“array.forEach(function(当前元素,索引,数组){...})”；该方法不处理空数组。
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
AI Hentai Generator
Generate AI Hentai for free.
Hot Article
Hot Tools
mPDF
mPDF is a PHP library that can generate PDF files from UTF-8 encoded HTML. The original author, Ian Back, wrote mPDF to output PDF files "on the fly" from his website and handle different languages. It is slower than original scripts like HTML2FPDF and produces larger files when using Unicode fonts, but supports CSS styles etc. and has a lot of enhancements. Supports almost all languages, including RTL (Arabic and Hebrew) and CJK (Chinese, Japanese and Korean). Supports nested block-level elements (such as P, DIV),
MantisBT
Mantis is an easy-to-deploy web-based defect tracking tool designed to aid in product defect tracking. It requires PHP, MySQL and a web server. Check out our demo and hosting services.
SAP NetWeaver Server Adapter for Eclipse
Integrate Eclipse with SAP NetWeaver application server.
Atom editor mac version download
The most popular open source editor
MinGW - Minimalist GNU for Windows
This project is in the process of being migrated to osdn.net/projects/mingw, you can continue to follow us there. MinGW: A native Windows port of the GNU Compiler Collection (GCC), freely distributable import libraries and header files for building native Windows applications; includes extensions to the MSVC runtime to support C99 functionality. All MinGW software can run on 64-bit Windows platforms.
