Detailed explanation of JSP export Excel table example
- 怪我咯Original
- 2017-06-26 11:52:272162browse
There are many examples of exporting jsp pages to Excel tables on the Internet, but many of them require the front-end and back-end to be interconnected. In my example here, I only need to write code on the jsp page to achieve it. The code is as follows:
testExcel.jsp page code:
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html xmlns:x="urn:schemas-microsoft-com:office:excel">
<script type="text/javascript">
function exportExcel(){
window.open('testExcel.jsp?exportToExcel=YES');
}
</script>
<head>
<!-- 显示网格线 -->
<xml>
<x:ExcelWorkbook>
<x:ExcelWorksheets>
<x:ExcelWorksheet>
<x:Name>工作表标题</x:Name>
<x:WorksheetOptions>
<x:Print>
<x:ValidPrinterInfo />
</x:Print>
</x:WorksheetOptions>
</x:ExcelWorksheet>
</x:ExcelWorksheets>
</x:ExcelWorkbook>
</xml>
<!-- 显示网格线 -->
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Export to Excel - Demo</title>
</head>
<body>
<%
String exportToExcel = request.getParameter("exportToExcel");
if (exportToExcel != null
&& exportToExcel.toString().equalsIgnoreCase("YES")) {
response.setContentType("application/vnd.ms-excel");
response.setHeader("Content-Disposition", "inline; filename="
+ "excel.xls");
}
%>
<table align="left" border="2">
<thead>
<tr bgcolor="lightgreen">
<th>ID</th>
<th>文本内容</th>
<th>序列</th>
<td style="display: none">序列222</td>
</tr>
</thead>
<tbody>
<%
for (int i = 0; i < 10; i++) {
%>
<tr bgcolor="lightblue">
<td align="center"><%=i%></td>
<td align="center">文本内容 <%=i%></td>
<td align="center"><%=i*10%></td>
<td style="display: none" align="center"><%=i * 20%></td>
</tr>
<%
}
%>
</tbody>
</table>
<br><br><br><br><br><br><br><br><br><br><br><br><br><br><br>
<%
if (exportToExcel == null) {
%>
<a href="javascript:exportExcel();">导出为Excel</a>
<%
}
%>
</body>
</html>PS: When you click the "Export to excel" hyperlink, the content of all pages will be exported to excel. However, we may not want the "Export to excel" hyperlink to appear in excel. In order to prevent it from appearing, we added a judgment condition to judge whether the exportToExcel parameter appears. If it appears, it means that the content will be exported to excel and hyperlinks will not be included. On the contrary, it means that we just want the browser to display the web page, then the hyperlink will appear on the page.
The above is the detailed content of Detailed explanation of JSP export Excel table example. For more information, please follow other related articles on the PHP Chinese website!