Export to Excel, PDF, CSV and XML using Display tag Example
In this tutorial you will learn how to export a datagrid to excel,
pdf, cvs or xml file using display tag in Struts. You will also see how
to use the group and the media attributes of the display:column tag.
Using display tag library, we can export the data grid as excel, pdf, csv and xml. In the following example we will see how to dispaly data using display tag and to export as excel, pdf, csv and xml.
The following jar files should be placed in the WEB-INF/lib directory
itext-1.3.jar file is required incase of exporting to pdf. displaytag-export-poi-1.2.jar is requried to export the file as csv, xml and excel.The following taglib directive should be placed in each JSP page that uses the display tag.
In this example we will display a list of actor's details like name, email Id and the TV show in which they performed. In this example we have a ActorData class which store the actor's details like name, email id and the tv show. The ActorData class has a loadData() method which returns an ArrayList of all the actor details.
The following attributes and methods are present in the ActorData class.
In the execute() method of the UserAction class, the loadData() method of ActorData class is called. This method will return an ArrayList of actors, that ArrayList is stored in the actorList attribute of the UserForm class.
The export attribute of the table tag should be set to true, inorder to export the data grid. After setting the value the data grid can be exported to excel, csv and xml. If you want to export to pdf then the "export.pdf" property to true.
By default the name of the export file will be the name of the jsp page. You can change the name of the pdf file by setting the "export.pdf.filename" property value to the desired file name. In the similar way you can change the name of the excel file by setting "export.excel.filename" property to a desired file name.
The name attribute of the table tag hold the name of the list in the form. The id value specifies an instance name for the ArrayList. The pagesize attribute holds the number of records to be displayed in each page.
The property attribute of the column tag hold the value of the property to be displayed in this each column. The value of the property can be any one of the property of the ActorData class. The ActorData class should have a getter method for that corresponding property. For instance if the property name is tvShow then their should be a corresponding getTvShow() method in the ActorData class.
If the sortable attribute of the column tag is set to "true" then that column will be sortable.
The group attribute of the column tag is set to "1"
, which means each unique data will be displayed only once and will not be repeated for the subsequent times.
The following image shows the first page of the data grid. Since the pagesize is set to ten, ten records are displayed in the first page.
On clicking the Excel link the user will be prompted to open or save the file.
On clicking open the data grid will be displayed in Excel format.
The media property of the column tag is used to specify in which media that column should be shown. If the media is set to
"html" then only in the jsp page that particular column will be displayed. If the media is set to "html, excel" then that particular column will be displayed in jsp page as well as in excel.