导出xls文件案例记录

import java.io.IOException;
import java.io.OutputStream;
import java.util.List;


import javax.servlet.ServletOutputStream;
import javax.servlet.http.HttpServletResponse;


import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.struts2.ServletActionContext;
import org.apache.struts2.convention.annotation.Action;
import org.apache.struts2.convention.annotation.Namespace;
import org.apache.struts2.convention.annotation.ParentPackage;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.context.annotation.Scope;
import org.springframework.stereotype.Controller;


import cn.itcast.bos.domain.take_delivery.WayBill;
import cn.itcast.bos.service.take_delivery.WayBillservice;
import cn.itcast.bos.utils.FileUtils;
import cn.itcast.bos.web.action.base.common.BaseAction;
@Namespace("/")
@ParentPackage("json-default")
@Controller
@Scope("prototype")
public class WayBillExportAction extends BaseAction<WayBill> {
//注入service 对象
@Autowired
private WayBillservice wayBillservice ;
/**
* 定义导出运单表方法
* @throws Exception 
*/
@Action(value="wayBillManage_export")
public String exportXls() throws Exception{
//查询数据
List<WayBill> wayBills = wayBillservice.findAll(model);

//导出数据\
//创建生成工作簿
HSSFWorkbook workBook = new HSSFWorkbook();
//创建工作簿页对象
HSSFSheet hssfSheet = workBook.createSheet("运单数据");
//创建第一行对象
HSSFRow headRow = hssfSheet.createRow(0);
//添加表头信息
headRow.createCell(0).setCellValue("运单号");
headRow.createCell(1).setCellValue("寄件人");
headRow.createCell(2).setCellValue("寄件人电话");
headRow.createCell(3).setCellValue("寄件人公司");
headRow.createCell(4).setCellValue("寄件人详细地址");
headRow.createCell(5).setCellValue("收件人");
headRow.createCell(6).setCellValue("收件人电话");
headRow.createCell(7).setCellValue("收件人公司");
headRow.createCell(8).setCellValue("收件人详细地址");
headRow.createCell(9).setCellValue("产品类型");
headRow.createCell(10).setCellValue("支付类型");
//将查询结果封装到表中

for (WayBill wayBill : wayBills) {
//创建行
HSSFRow dataRow = hssfSheet.createRow(hssfSheet.getLastRowNum() + 1);

dataRow.createCell(0).setCellValue(wayBill.getWayBillNum());
dataRow.createCell(1).setCellValue(wayBill.getSendName());
dataRow.createCell(2).setCellValue(wayBill.getSendMobile());
dataRow.createCell(3).setCellValue(wayBill.getSendCompany());
dataRow.createCell(4).setCellValue(wayBill.getSendAddress());
dataRow.createCell(5).setCellValue(wayBill.getRecName());
dataRow.createCell(6).setCellValue(wayBill.getRecMobile());
dataRow.createCell(7).setCellValue(wayBill.getRecCompany());
dataRow.createCell(8).setCellValue(wayBill.getRecAddress());
dataRow.createCell(9).setCellValue(wayBill.getRecAddress());
dataRow.createCell(10).setCellValue(wayBill.getPayTypeNum());
}
//两个头一个流Content-type:内容类型,Content-Disposition:内容策略
//获取页面响应对象
HttpServletResponse resp = ServletActionContext.getResponse();
//生成浏览器响应流
//内容类型响应头
resp.setContentType("application/vnd.ms-excel");
String filename = "运单数据.xls";
String agent = ServletActionContext.getRequest().getHeader("user-agent");
//处理中文
filename = FileUtils.encodeDownloadFilename(filename, agent );
//设置内容策略
resp.setHeader("Content-Disposition", "attachment;filename="+filename);
ServletOutputStream outputStream = resp.getOutputStream();
//讲数据输出到本地
workBook.write(outputStream);
//关闭工作簿
workBook.close();
return NONE;
}
}