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

1.struts.xml的action相关配置:

<action name="ExportAction" 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> 

2.JAVA的ExportAction类:

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

3.页面提交:

<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