struts2实现excel导出

1、用到的是poi的包。在apache的网站上去下poi-bin-3.2-FINAL-20081019.zip，目前最新的版本。直接上代码了：action:import com.opensymphony.xwork2.ActionContext;import com.opensymphony.xwork2.ActionSupport;import com.ps.model.UserBizInfo;import java.io.File;import java.io.FileInputStream;import java.io.FileOutputStream;import java.io.Inpu

2、tStream;import java.io.OutputStream;import java.util.List;import java.util.Map;import org.apache.poi.hssf.usermodel.HSSFCell;import org.apache.poi.hssf.usermodel.HSSFRichTextString;import org.apache.poi.hssf.usermodel.HSSFRow;import org.apache.poi.hssf.usermodel.HSSFSheet;import org.apache.poi.hssf.

3、usermodel.HSSFWorkbook;public class ExcelDownloadAction extends ActionSupport public InputStream getInputStream() Map session=ActionContext.getContext().getSession(); List<UserBizInfo> list=(List<UserBizInfo>)session.get("ecxelUserBizInfolist"); HSSFWorkbook wb = new HSSFWorkbo

4、ok(); HSSFSheet sheet = wb.createSheet("sheet1"); int rowNum = 0; / 标题开始行 int colNum = 0; / 标题开始列 / HSSFRow excell的头 HSSFRow row = sheet.createRow(rowNum+); / HSSFCell excell的格子单元 HSSFCell cell = row.createCell(short)colNum+); cell.setCellValue("Id"); cell = row.createCell(short)

5、colNum+); cell.setCellValue("用户名"); cell = row.createCell(short)colNum+); cell.setCellValue("类型"); for(UserBizInfo user : list) row = sheet.createRow(rowNum+); colNum=0; cell = row.createCell(short) colNum+); /cell.setCellStyle(cellStyle); String userid=String.valueOf(user.getUse

6、rId(); cell.setCellValue(new HSSFRichTextString(userid); cell = row.createCell(short) colNum+); /cell.setCellStyle(cellStyle); cell.setCellValue(new HSSFRichTextString(user.getUserName(); cell = row.createCell(short) colNum+); /cell.setCellStyle(cellStyle); int type=user.getUserType(); String userty

7、pe="不限" if(type=1) usertype="一般用户" else if(type=2) usertype="摄影师" cell.setCellValue(new HSSFRichTextString(usertype); File file = new File("abc.xls"); /创建一个File 拿来当缓存用.也就是先将内存中的excel写入File中.然后再将File转换成输出流 try OutputStream out = new FileOutputStream(file); wb.w

8、rite(out);/写入File out.close(); catch (Exception e) e.printStackTrace(); InputStream in = null; try in = new FileInputStream(file);/将file转换成输入流 /in.close(); catch (Exception e) / TODO Auto-generated catch block e.printStackTrace(); return in; public String execute() throws Exception try return SUCCES

9、S; catch (Exception e1) e1.printStackTrace(); return ERROR; struts2配置<action name="excel" class="com.ps.action.adminaction.ExcelDownloadAction"> <result name="success" type="stream"> <param name="contentType">application/vnd.ms-excel</param> <param name="contentDisposition">attachment;filename="AllUsers.xls"</param> <p