Struts2简单导出数据到excel中方法（实例）

JSP页面:

<a href="exportExcel.action">导出</a>

struts.xml:

<action name="exportExcel" class="vs.dascsl.newmodel.businessmgr.modelimport.action.ModelImportAction" method="exportExcel">      
            <result name="excel" type="stream">
                <param name="contentType">application/vnd.ms-excel</param>
                <param name="inputName">excelStreamName</param>            
                <param name="contentDisposition">attachment;filename="${downloadFileName}"</param>
                <param name="bufferSize">1024</param>
            </result>
        </action>

Action类:

public class ModelImportAction extends BaseAction{
    private String downloadFileName = "";
    private transient InputStream excelStreamName = null;    
    /**
     * 方法描述：导出Excel模板.
     * <p/>
     * @return
     * @throws Exception  
     * 创建时间：2017-6-7 上午9:11:22
     */
    public  String exportExcel() throws Exception {
        String fileName = "业务调研与分析成果_分析化验,20170531100300.xls";
        String filePath=this.realpath +"\\"+fileName;
        setDownloadFileName("模型模板.xls");
        excelStreamName = new FileInputStream(filePath);
        return "excel";
    }
    public String getDownloadFileName() throws UnsupportedEncodingException {
        return downloadFileName;
    }
    public void setDownloadFileName(String downloadFileName) {
        this.downloadFileName = downloadFileName;
    }
    public InputStream getExcelStreamName() {
        return excelStreamName;
    }
    public void setExcelStreamName(InputStream excelStreamName) {
        this.excelStreamName = excelStreamName;
    }
}