Excel file download in Struts2 using apache POI

Here I am explaining how to export data from action to xml file.
For that we are using apache poi
We have included following jar files in lib folder

import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.usermodel.Row;


public class ProductDetailsAction extends ActionSupport {
 private long barCode;//bardoce
 private long productName;
 private ArrayList<ProductDetailsAction> productList;
 private InputStream inputStream;
 /getter and setter of all fields

public String Download()
{


               ProductDetailsAction pda=new ProductDetailsAction();
                pda.setBarCode(111);
                pda.setProductName("Lux");
                setProductList(pda);                
                pda.setBarCode(112);
                pda.setProductName("Liril");
                setProductList(pda);                
                pda.setBarCode(113);
                pda.setProductName("Hamam");
                setProductList(pda);
                HSSFWorkbook myWorkBook = new HSSFWorkbook();
                HSSFSheet mySheet = myWorkBook.createSheet();
                HSSFRow myRow = null;

                int rowNum = 1;
                Row header = mySheet.createRow(0);
                header.createCell(0).setCellValue("BARCODE");
                header.createCell(1).setCellValue("productName");
               
                 for (ProductDetailsAction s : getProductList()) {
                    myRow = mySheet.createRow(rowNum++);

                    Row dataRow = mySheet.createRow(rowNum++);
                    dataRow.createCell(0).setCellValue(s.getBarCode());
                    dataRow.createCell(1).setCellValue(s.getProductName());
                }
                try {

                    ByteArrayOutputStream baos = new ByteArrayOutputStream();
                    myWorkBook.write(baos);
                    setInputStream(new ByteArrayInputStream(boas.toByteArray()));
       
                } catch (Exception e) {
                    e.printStackTrace();
                }
                return SUCCESS;
}

import org.apache.poi.hssf.usermodel.HSSFRow;

import org.apache.poi.hssf.usermodel.HSSFSheet;

import org.apache.poi.hssf.usermodel.HSSFWorkbook;

import org.apache.poi.ss.usermodel.Row;

public class ProductDetailsAction extends ActionSupport {

private long barCode;//bardoce

private long productName;

private ArrayList<ProductDetailsAction> productList;

private InputStream inputStream;

/getter and setter of all fields

public String Download()

{

ProductDetailsAction pda=new ProductDetailsAction();

pda.setBarCode(111);

pda.setProductName("Lux");

setProductList(pda);

pda.setBarCode(112);

pda.setProductName("Liril");

setProductList(pda);

pda.setBarCode(113);

pda.setProductName("Hamam");

setProductList(pda);

HSSFWorkbook myWorkBook = new HSSFWorkbook();

HSSFSheet mySheet = myWorkBook.createSheet();

HSSFRow myRow = null;

int rowNum = 1;

Row header = mySheet.createRow(0);

header.createCell(0).setCellValue("BARCODE");

header.createCell(1).setCellValue("productName");

for (ProductDetailsAction s : getProductList()) {

myRow = mySheet.createRow(rowNum++);

Row dataRow = mySheet.createRow(rowNum++);

dataRow.createCell(0).setCellValue(s.getBarCode());

dataRow.createCell(1).setCellValue(s.getProductName());

}

try {

ByteArrayOutputStream baos = new ByteArrayOutputStream();

myWorkBook.write(baos);

setInputStream(new ByteArrayInputStream(boas.toByteArray()));

} catch (Exception e) {

e.printStackTrace();

}

return SUCCESS;

}

In struts.xml

<action name="DownloadProduct" 
        class="iland.productdetails.ProductDetailsAction" method="DownloadAll">
   <result name="success" type="stream">
           <param name="contentDisposition">attachment;filename=report.xls</param>
           <param name="contentType">application/vnd.ms-excel</param>
           <param name="inputName">inputStream</param>
  <!--inputName is the name of InputStream's variable, Here this is inputStream; -->
           <param name="bufferSize">1024</param>
   </result>
 </action>

<action name="DownloadProduct"

class="iland.productdetails.ProductDetailsAction" method="DownloadAll">

<param name="contentDisposition">attachment;filename=report.xls</param>

<param name="contentType">application/vnd.ms-excel</param>

<param name="inputName">inputStream</param>

</result>

</action>

In jsp

 <s:a href="DownloadProduct">Download</s:a>

1	<s:a href="DownloadProduct">Download</s:a>