01.<%@page contentType="text/html" pageEncoding="UTF-8"%>02.<%@taglib uri="/WEB-INF/struts-logic.tld" prefix="logic" %>03.<%@taglib uri="/WEB-INF/struts-bean.tld" prefix="bean" %>04.<html>05.<head>06.<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">07.<title>User Details</title>08.</head>09.<body>10.<table cellpadding="3" cellspacing="3" border="1">11.<tr>12.<th>13.User Name14.</th>15.<th>16.Email Id17.</th>18.<th>19.Location20.</th>21.</tr>22.<logic:iterate id="data" name="ExcelForm" property="userList">23.<tr>24.<td>25.<bean:write name="data" property="userName" />26.</td>27.<td>28.<bean:write name="data" property="emailId" />29.</td>30.<td>31.<bean:write name="data" property="location" />32.</td>33.</tr>34.</logic:iterate>35.</table>36.<a href="exportUser.jsp" >Excel</a>37.</body>38.</html>
In the user.jsp page we iterate the userList using the <logic:iterate> tag. The id attribute of the <logic:iterate> tag holds an instance of the data present in the userList. userList contains a list of UserData. So the id attribute holds an instance of the UserData. Using the <bean:write> tag we display the data present in the UserData.
The exportUser.jsp page contains the following contents.
01.<%@page contentType="application/vnd.ms-excel" pageEncoding="UTF-8"%>02. 03.<%@taglib uri="/WEB-INF/struts-logic.tld" prefix="logic" %>04.<%@taglib uri="/WEB-INF/struts-bean.tld" prefix="bean" %>05.<html>06.<head>07.<title>User Details</title>08.</head>09.<body>10.<table cellpadding="3" cellspacing="3" border="1">11.<tr>12.<th>13.User Name14.</th>15.<th>16.Email Id17.</th>18.<th>19.Location20.</th>21.</tr>22.<logic:iterate id="data" name="ExcelForm" property="userList">23.<tr>24.<td>25.<bean:write name="data" property="userName" />26.</td>27.<td>28.<bean:write name="data" property="emailId" />29.</td>30.<td>31.<bean:write name="data" property="location" />32.</td>33.</tr>34.</logic:iterate>35.</table>36.</body>37.</html>
The user.jsp page contains the following user details.
On clicking the Excel link in the user.jsp page. The userDetails.jsp page will be displayed in the Excel fromat.
1.<bean:write name="data" property="userName" />
The above mentioned tag calls the getUserName() method of the UserData class and displays the user name. A link is provided to export the exportUser.jsp page to excel. The exportUser.jsp page contains similar data like the user.jsp page except the contentType attribute of the page directive, which is set to application/vnd.ms-excel.
No comments:
Post a Comment