下载并导出数据到execl中

下载poi-3.6-20091214.jar，下载地址如下：

http://download.csdn.net/detail/evangel_z/3895051

1.jsp

<button type="button" class="btn btn-mini" onClick="location.href='<%=basePath%>/bankcard/exportEffectThirdData?begintime=${begintime}&endtime=${endtime}&page=1'">导出有效订单</button>

2.后台代码处理：

 controller 处理：

@Get("exportReturnThirdData")
 public  void  exportReturnThirdListData(Invocation inv,@Param("begintime") String startTime,
   @Param("endtime") String endTime){
  HttpServletResponse response = inv.getResponse();
  // response.setContentType("application/xls");
  response.setContentType("application/x-download");
  response.reset();
  response.setContentType("bin");
  String header = "attachment;filename=returnThirdData.xls";
  response.addHeader("Content-Disposition", header);

  String[] heads = { "订单日期", "订单号", "商品名称", "商品属性", "渠道名称", "支付银行卡","支付账号", "成本价", "卖出价", "卖出收入", "发货日期", "外订单审核日期", "退货日期", "取消日期" };
  List<FenqiGoodsOrder> returnOrders = fenqiGoodsOrderListService
    .exportReturnThirdList(startTime, endTime);
  String path = "";

  OrderDetailExportExeclUtil.exeportListData(heads, returnOrders,response);
 }

导出到execl处理逻辑：

public static void  exeportListData(String[] heads,List<FenqiGoodsOrder> returnOrders,HttpServletResponse response){
  // 第一步，创建一个webbook，对应一个Excel文件  
        HSSFWorkbook wb = new HSSFWorkbook(); 
       // 第二步，在webbook中添加一个sheet,对应Excel文件中的sheet  
        HSSFSheet sheet = wb.createSheet("第三方退货订单明细"); 
       // 第三步，在sheet中添加表头第0行,注意老版本poi对Excel的行数列数有限制short  
        HSSFRow row = sheet.createRow((int) 0); 
     // 第四步，创建单元格，并设置值表头 设置表头居中  
     HSSFCellStyle style = wb.createCellStyle(); 
     style.setAlignment(HSSFCellStyle.ALIGN_CENTER); // 创建一个居中格式  

     HSSFCell cell=null;
         for(int h=0;h<heads.length;h++){
          cell = row.createCell((short) h); 
          cell.setCellValue(heads[h]); 
       cell.setCellStyle(style); 
         }
     // 第五步，写入实体数据 实际应用中这些数据从数据库得到，  
        for (int i = 0; i < returnOrders.size(); i++) 
       { 
            row = sheet.createRow((int) i + 1); 
            FenqiGoodsOrder goodsOrder = (FenqiGoodsOrder) returnOrders.get(i); 
           // 第四步，创建单元格，并设置值  
            row.createCell((short) 0).setCellValue(new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(goodsOrder.getCreateTime())); 
            row.createCell((short) 1).setCellValue(goodsOrder.getOrderNo()); 
            row.createCell((short) 2).setCellValue(goodsOrder.getGoodName()); 
            row.createCell((short) 3).setCellValue(goodsOrder.getGoodType());
            row.createCell((short) 4).setCellValue(goodsOrder.getChannelName()); 
            row.createCell((short) 5).setCellValue(goodsOrder.getCardNo()); 
            row.createCell((short) 6).setCellValue(goodsOrder.getAccountNo()); 
            row.createCell((short) 7).setCellValue(goodsOrder.getPurchasePrice());//成本价
            row.createCell((short) 8).setCellValue(goodsOrder.getSellPrice());//卖出价
            row.createCell((short) 9).setCellValue(goodsOrder.getSellEarning());//卖出收入 
            if(goodsOrder.getDeliveryTime() !=null && !goodsOrder.getDeliveryTime().equals("")){
             row.createCell((short) 10).setCellValue(new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(goodsOrder.getDeliveryTime())); 
            }
            if(goodsOrder.getAuditTime() !=null && !goodsOrder.getAuditTime().equals("")){
             row.createCell((short) 11).setCellValue(new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(goodsOrder.getAuditTime()));
            }
            if(goodsOrder.getReturnTime() !=null && !goodsOrder.getReturnTime().equals("")){
             row.createCell((short) 12).setCellValue(new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(goodsOrder.getReturnTime())); 
            }
            if(goodsOrder.getCancelDate() !=null && !goodsOrder.getCancelDate().equals("")){
             row.createCell((short) 13).setCellValue(new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(goodsOrder.getCancelDate()));
            }
         } 
         // 第六步，将文件存到指定位置  
        try 
        { 
         wb.write(response.getOutputStream()); 
        } 
       catch (Exception e) 
       { 
            e.printStackTrace(); 
        } 
  
 }

 

 

 http://www.cnblogs.com/bmbm/archive/2011/12/08/2342261.html