• 导出excel(利用工具类导出excel)


    /**
    * 添加导出功能
    * @param creditPageResult
    * @param request
    * @param response
    */
    @RequestMapping(value = "export")
    public void export(CreditPageResult creditPageResult, HttpServletRequest request, HttpServletResponse response) {
    creditPageResult.setPageSize(10000000);
    CreditApiResult<CreditApiPage<CreditDto>> resultMap=trialService.firstfindHistoryResult(creditPageResult);
    List<CreditDto> listCredit=new ArrayList<CreditDto>();
    if (isResultSuccess(resultMap)) {
    CreditApiPage<CreditDto> nowData = resultMap.getData();
    listCredit=nowData.getEntities();
    }
    trialService.exportHistory(response, listCredit, (int)creditPageResult.getAuditType());
    }

    /**
    * 添加导出功能
    *
    * @param response
    * @param dataList
    */
    public void exportHistory(HttpServletResponse response, Collection<CreditDto> dataList, Integer type) {
    try {
    String str = "";
    if ((int) type == 1) {
    str = "初审历史记录表";
    String[] excelHeader = {"姓名#userName", "电话#phone"};
    ExportExcelUtils.export(response, str, excelHeader, dataList);
    }
    if ((int) type == 2) {
    str = "复审历史记录表";
    String[] excelHeader = {"姓名#userName", "电话#phone",};
    ExportExcelUtils.export(response, str, excelHeader, dataList);
    }

    } catch (NoSuchMethodException e) {
    e.printStackTrace();
    } catch (SecurityException e) {
    e.printStackTrace();
    } catch (IllegalAccessException e) {
    e.printStackTrace();
    } catch (IllegalArgumentException e) {
    e.printStackTrace();
    } catch (InvocationTargetException e) {
    e.printStackTrace();
    } catch (IOException e) {
    e.printStackTrace();
    }

    }

  • 相关阅读:
    C#指南,重温基础,展望远方!(3)类型和变量
    C#指南,重温基础,展望远方!(2)程序结构
    C#指南,重温基础,展望远方!(1)C#语言介绍
    ASP.NET MVC 简单的分页思想与实现
    ASP.NET MVC实现网站验证码功能
    hdu
    多种方法实现实现全排列 + sort调用标准函数库函数的简述
    HDU
    <hdu
    NYOJ-括号配对问题 <技巧性的非栈道法>
  • 原文地址:https://www.cnblogs.com/austinspark-jessylu/p/7103296.html
Copyright © 2020-2023  润新知