导出 1

最新推荐文章于 2023-04-19 20:46:45 发布

√√√√√_文

最新推荐文章于 2023-04-19 20:46:45 发布

阅读量114

点赞数

分类专栏：基础知识2 基础知识文章标签：导出excel

本文链接：https://blog.csdn.net/qq_27551075/article/details/81630354

版权

基础知识同时被 2 个专栏收录

50 篇文章 0 订阅

订阅专栏

基础知识2

8 篇文章 0 订阅

订阅专栏

public void doExport1(HttpServletRequest request, HttpServletResponse response,RptQueryBean bean,Map valueStack)
   {
       RptExcelMode mode=bean.getRptExcelMode1(valueStack);
       String modUrl=request.getSession().getServletContext().getRealPath(
               File.separator)+mode.getModUrl();
       mode.setModUrl(modUrl);
       ServletOutputStream out = null;
       try {
           List list=mode.getDataList();
           if(list==null || list.size()<=0)
           {
               list=bean.queryNoPage(valueStack);
               mode.setDataList(list);
           }
           HSSFWorkbook wb=mode.getWorkbook();
           String fileName=mode.getFileName();
           response.reset();
           response.setContentType("application/vnd.ms-excel");
           response.setHeader("Content-Disposition", "attachment;filename=" + fileName);
           out = response.getOutputStream();
           wb.write(out);
           out.flush();
       } catch (Exception e) {
           // TODO Auto-generated catch block
           e.printStackTrace();
       }finally{
           try {
               out.close();
           } catch (IOException e) {
               e.printStackTrace();
           }
       }
}

----------------------------------------------------

public RptExcelMode getRptExcelMode1(Map valueStack) {
       String [][] cellInfo = null;
       String[][] cellInfo1 = {
               {"RG2","Double"},
               {"RG2_NAME","String"},
               {"RG3","Double"},
               {"RG3_NAME","String"},
               {"ORG5","Double"},
               {"ORG5_NAME","String"},
               {"AGENT_CODE","Double"},
               {"AGENT_NAME","String"},

               {"YYQ","Double"},
               {"YYQ_NAME","String"},
               {"YYB","Double"},
               {"YYB_NAME","String"},
               {"YYZ","Double"},
               {"YYZ_NAME","String"},
               {"SOURCE_AGENT_CODE","Double"},
               {"SOURCE_AGENT_NAME","String"},
               /*明细*/
               {"POLICY_CODE","String"}, //保单号
               {"PERIOD_PREM","Double"}, //应缴保费
               {"POLICY_PERIOD","String"}, //缴次
               {"SELL_CHANNEL","String"}, //渠道
               {"IS_SPECIAL","String"}, //续期服务类型
               {"VALIDATE_DATE","String"}, //生效时间
               {"DUE_TIME","String"}, //应缴时间
               {"SOURCE_AGENT_TYPE","String"}, //代理人类别
               {"LINK_TIME","String"}, //拜访时间
               {"LINK_TYPE","String"}, //拜访方式
               {"VISIT_AGENT_NAME","String"},//拜访人
               {"IS_SUCCESS","String"}, //拜访是否成功
               {"AGENT_JOBCODE","String"}, //代理人职级
               {"VISITSTATES","String"}, //拜访阶段
               {"IS_SUPERVISE","String"}, //考核类型
               {"MEMO","String"}, //拜访详情描述
       }   ;
       cellInfo=cellInfo1;
       String dateValue="统计时间："+((String)valueStack.get("returnStart"))+"~"+((String)valueStack.get("returnEnd"));

       String fileName = "拜访量统计报表明细.xls";
       String sheetName="拜访量统计报表明细";
       String url=null;

       String url1="/excel/da/rpt/cs/as/visitReportMore.xls";
       url=url1;
       RptExcelMode mode=new RptExcelMode(url, fileName, sheetName,
           dateValue, 1, 0, 3,0, RptExcelMode.SHEETCHANGE, RptExcelMode.TYPESIGNLE, cellInfo);
       return mode;
}