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;    }}