struts2自带excel导出功能

最新推荐文章于 2021-02-02 16:59:51 发布

gongblack0

最新推荐文章于 2021-02-02 16:59:51 发布

阅读量173

点赞数

分类专栏： struts2自带excel导出功能文章标签： struts excel

本文链接：https://blog.csdn.net/gongblack0/article/details/84279689

版权

struts2自带excel导出功能专栏收录该内容

0 篇文章 0 订阅

订阅专栏

struts2中有对导出excel表格的支持，所以开发起来比较容易，主要的步骤有三点：

[size=medium][color=red]1.struts.xml的action相关配置: [/color][/size]

<action name="ExportAction" class="com.huawei.nsm.workflow.action.ExportAction">
 <result name="excel" type="stream"> 

               <!-- 注意这里的ContentType --> 
               <param name="contentType">application/vnd.ms-excel</param> 

                <!-- 这里需要和Action里的变量名一致 -->   

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

               <param name="contentDisposition">filename="export.xls"</param> 
               <param name="bufferSize">1024</param> 
        </result> 
</action>

[size=medium][color=red]2.JAVA的ExportAction类:[/color][/size]

public class ExportAction extends ActionSupport { 

private QueryDao dao = new QueryDao(); 

private InputStream excelStream; 

public InputStream getExcelStream() { 
return excelStream; 
} 

public void setExcelStream(InputStream excelStream) { 
this.excelStream = excelStream; 
} 

@Override 
public String execute() throws Exception { 
StringBuffer excelBuf = new StringBuffer(); 
excelBuf.append("编号").append("\t").append("国家").append("\t").append("\n"); 

List<Country> list1 = dao.getCountryData(); 
for (int i = 0; i < list1.size(); i++) { 
Country country = (Country) list1.get(i); 
excelBuf.append(country.getId()).append("\t") 
.append(country.getName()).append("\t") 
.append("\n"); 
} 
String excelString = excelBuf.toString(); 
excelStream = new ByteArrayInputStream(excelString.getBytes(), 0, 
excelString.length()); 
return "excel"; 
} 

}

[size=medium][color=red]

3.页面提交: [/color][/size]

<form action="<%=path %>/ExportAction.action" enctype="MULTIPART/FORM-DATA" method="post">
 <input type="submit" value="导出excel"> 
</form>

以上就是struts2自带的excel导出功能.其实如果想使导出的excel变得更漂亮,就使用apache的poi包,有以下几类:
poi-3.7-20101029.jar
poi-ooxml-3.7-20101029.jar
poi-ooxml-schemas-3.7-20101029.jar,
poi-scratchpad-3.7-20101029.jar