In this, the emphasis on the search keyword importance, so that you can immediately locate the article, otherwise in elephant, no purpose awkward situation. This article is found through the export JSP to Excel.
The original address: How to Export the Web Page to Excel (in JSP)?
In this tutorial we will see how to export JSP pages to Excel and add the ability to export Excel to existing JSP pages.
Many times it is convenient for users to see the content of the page in Excel. Public schemes are exported to forms that contain information such as reports, numbers, and so on. Exporting data to Excel, end users can also use Excel to do various analyses, which is difficult for your Java Basic program to implement.
Let's say this is your JSP page:
This is the corresponding JSP source code (export Excel function has not added). A JSP page that contains a simple data table.
[Java]View PlainCopy print?
- <%@ page language="java" contenttype="text/html; Charset=iso-8859-1 "
- pageencoding="Iso-8859-1"%>
- <! DOCTYPE HTML public "-//W3C//DTD HTML 4.01 transitional//en" "Http://www.w3.org/TR/html4/loose.dtd" > " /c7>
- <meta http-equiv="Content-type" content= "text/html; Charset=iso-8859-1 ">
- <title>export to Excel-demo</title>
- <body>
- <table align="center" border="2" >
- <thead>
- <tr bgcolor="LightGreen" >
- <TH>SR. no.</th>
- <th>text data</th>
- <th>number data</th>
- </tr>
- </thead>
- <tbody>
- <%
- For (int i = 0; i < i++) {
- %>
- <tr bgcolor="LightBlue" >
- <TD align="center" ><%=i%></td>
- <TD align="center" >this is text data <%=i%></td>
- <TD align="center" ><%=i * i%></td>
- </tr>
- <%
- }
- %>
- </tbody>
- </table>
- </body>
We'll add a "Export to Excel" hyperlink that will export the page content to an Excel file. Then this page will look like this:
The following is a new version of the JSP source code. This version adds the "Export to Excel" hyperlink, and adds the appropriate functionality:
[Java]View PlainCopyprint?
- <%@ page language="java" contenttype="text/html; Charset=iso-8859-1 "
- pageencoding="Iso-8859-1"%>
- <! DOCTYPE HTML public "-//W3C//DTD HTML 4.01 transitional//en" "Http://www.w3.org/TR/html4/loose.dtd" > " /c3>
- <meta http-equiv="Content-type" content= "text/html; Charset=iso-8859-1 ">
- <title>export to Excel-demo</title>
- <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>SR. no.</th>
- <th>text data</th>
- <th>number data</th>
- </tr>
- </thead>
- <tbody>
- <%
- For (int i = 0; i < i++) {
- %>
- <tr bgcolor="LightBlue" >
- <TD align="center" ><%=i + 1%></td>
- <TD align="center" >this is text data <%=i%></td>
- <TD align="center" ><%=i * i%></td>
- </tr>
- <%
- }
- %>
- </tbody>
- </table>
- <br><br><br><br><br><br><br><br><br><br><br> <br><br><br><br>
- <%
- if (exporttoexcel = = null) {
- %>
- <a href="Excel.jsp?exporttoexcel=yes" >export to excel</a>
- <%
- }
- %>
- </body>
Export Web page to Excel code Explanation: 1) In this version of the JSP page, when you click the "Export to Excel" hyperlink, the request is sent to the same page (excel.jsp), but the accompanying URL parameter is exporttoexcel=yes.
[Java]View PlainCopyprint?
- <a href="Excel.jsp?exporttoexcel=yes" >export to excel</a>
2) The JSP page will check the correctness of the parameters at the beginning. If the value of this parameter is yes, we will see the content type in the response message, which identifies the Excel file name and opens it on the user's computer.
[Java]View PlainCopy print?
- string exporttoexcel = request.getparameter ( "exportToExcel");
- if (exporttoexcel != null
- && exporttoexcel.tostring (). Equalsignorecase ( "YES")) {
- response.setcontenttype (
- response.setheader ( "Content-disposition",
- &NBSP;&NBSP;&NBSP;
- }
3) When you click the "Export to Excel" hyperlink, the contents of all pages will be exported to Excel. However, we may not want to have the "Export to Excel" hyperlink come out of Excel. To prevent it from appearing, we have added a judgment condition to determine whether the exportToExcel parameter appears. If it does, it means that the content is exported to Excel and does not include hyperlinks. Conversely, it means that we just want the browser to display the page, then the hyperlink will appear on the page.
[Java]View PlainCopyprint?
- <%
- if (exporttoexcel = = null) {
- %>
- <a href="Excel.jsp?exporttoexcel=yes" >export to excel</a>
- <%
- }
- %>
Export page to Excel display but when you click the Hyperlink, a dialog box pops up asking if you want to open or save the file. Click Open and you will see the following: As you can see, the exported file will also save your formatting on the page. In the next tutorial, we'll see how to export a page to a Word file
- How to Export the Web Page to Word (in JSP)
You can download the Eclipse engineering file in the Code Interpretation section of this tutorial.
- Javaexcelexport.zip (5KB)
[end] =============================================
Attention:
If not set: Response.setheader ("Content-disposition", "attachment; Filename= "+ filename+". xls ");
Zemer considers the current page. xls.
For example testexcel.jsp---> Generate testexcel.xls form
Extended reading:
[1] generation of Excel and Word via HTTP protocol in JSP: After the author has used JXL, the HTTP method is chosen to generate Excel
[2] Jsp-excel save defualt in. xls extension, open EXCEL with in the browser:
[3] using the HTTP protocol to change the output file: The importance of the HTTP1.1 protocol
[4] Hypertext Transfer Protocol-http (Rev.): HTTP1.1 protocol explained in detail
[5] Multiple tables data exported to multiple worksheets of the same Excel sheet in Java: One in Excel, stored in multiple sheet
Save JSP page content to Excel (GO)
