Home >Java >javaTutorial >Detailed explanation of JSP export Excel table example

Detailed explanation of JSP export Excel table example

怪我咯Original: 2017-06-26 11:52:272286browse

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(&#39;testExcel.jsp?exportToExcel=YES&#39;);  
  }  
  
</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!

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：JAVAEE - Implementation of custom interceptors, struts2 tags, login functions and verification login interceptorsNext article：JAVAEE - Implementation of custom interceptors, struts2 tags, login functions and verification login interceptors

See more

Detailed explanation of JSP export Excel table example

Related articles