<ruby id="bdb3f"></ruby>

    <p id="bdb3f"><cite id="bdb3f"></cite></p>

      <p id="bdb3f"><cite id="bdb3f"><th id="bdb3f"></th></cite></p><p id="bdb3f"></p>
        <p id="bdb3f"><cite id="bdb3f"></cite></p>

          <pre id="bdb3f"></pre>
          <pre id="bdb3f"><del id="bdb3f"><thead id="bdb3f"></thead></del></pre>

          <ruby id="bdb3f"><mark id="bdb3f"></mark></ruby><ruby id="bdb3f"></ruby>
          <pre id="bdb3f"><pre id="bdb3f"><mark id="bdb3f"></mark></pre></pre><output id="bdb3f"></output><p id="bdb3f"></p><p id="bdb3f"></p>

          <pre id="bdb3f"><del id="bdb3f"><progress id="bdb3f"></progress></del></pre>

                <ruby id="bdb3f"></ruby>

                ##### 2.3.7 Excel多Sheet導出 目前單Sheet和單Class的方式比較多,對于多Sheet的方式還是一片空白,這里做一下說明: 導出基本采用ExportParams 這個對象,進行參數配置; 我們需要進行多Sheet導出,那么就需要定義一個基礎配置對象 ~~~ public class ExportView { public ExportView(){ } private ExportParams exportParams; private List<?> dataList; private Class<?> cls; public ExportParams getExportParams() { return exportParams; } public void setExportParams(ExportParams exportParams) { this.exportParams = exportParams; } public Class<?> getCls() { return cls; } public void setCls(Class<?> cls) { this.cls = cls; } public List<?> getDataList() { return dataList; } public void setDataList(List<?> dataList) { this.dataList = dataList; } public ExportView(Builder builder) { this.exportParams = builder.exportParams; this.dataList = builder.dataList; this.cls = builder.cls; } public static class Builder { private ExportParams exportParams=null; private List<?> dataList=null; private Class<?> cls=null; public Builder() { } public Builder exportParams(ExportParams exportParams) { this.exportParams = exportParams; return this; } public Builder dataList(List<?> dataList) { this.dataList = dataList; return this; } public Builder cls(Class<?> cls) { this.cls = cls; return this; } public ExportView create() { return new ExportView(this); } } } ~~~ 對象主要有三個屬性: // 該注解配置的導出屬性 1. ExportParams exportParams // 對應注解 class 實例對象的數據集合 2. List dataList // 對應注解的 class 3. Class cls 這里沒有用泛型,因為多Sheet導出時,會引用到不同的注解對象; 定義基礎配置的集合 ~~~ public class ExportMoreView { private List<ExportView> moreViewList=Lists.newArrayList(); public List<ExportView> getMoreViewList() { return moreViewList; } public void setMoreViewList(List<ExportView> moreViewList) { this.moreViewList = moreViewList; } } ~~~ 最后在實現調用的方法中,對整個集合進行配置和解析 ~~~ List<Map<String, Object>> exportParamList=Lists.newArrayList(); //該行主要用于獲取業務數據,請根據具體的情況進行修改和調整 ExportMoreView moreView=this.getBaseTransferService().mergeExportView(templateTypeCode); //迭代導出對象,將對應的配置信息寫入到實際的配置中 for(ExportView view:moreView.getMoreViewList()){ Map<String, Object> valueMap=Maps.newHashMap(); valueMap.put(NormalExcelConstants.PARAMS,view.getExportParams()); valueMap.put(NormalExcelConstants.DATA_LIST,view.getDataList()); valueMap.put(NormalExcelConstants.CLASS,view.getCls()); exportParamList.add(valueMap); } //實現導出配置 modelMap.put(NormalExcelConstants.FILE_NAME,new DateTime().toString("yyyyMMddHHmmss")); //將轉換完成的配置接入到導出中 modelMap.put(NormalExcelConstants.MAP_LIST,exportParamList); return NormalExcelConstants.JEECG_EXCEL_VIEW; ~~~ 如果不是采用的MVC的方式,請將轉換的配置采用以下的方式實現: 參見ExcelExportUtil ![](https://static.oschina.net/uploads/space/2017/1128/111045_9s7X_2343396.png)
                  <ruby id="bdb3f"></ruby>

                  <p id="bdb3f"><cite id="bdb3f"></cite></p>

                    <p id="bdb3f"><cite id="bdb3f"><th id="bdb3f"></th></cite></p><p id="bdb3f"></p>
                      <p id="bdb3f"><cite id="bdb3f"></cite></p>

                        <pre id="bdb3f"></pre>
                        <pre id="bdb3f"><del id="bdb3f"><thead id="bdb3f"></thead></del></pre>

                        <ruby id="bdb3f"><mark id="bdb3f"></mark></ruby><ruby id="bdb3f"></ruby>
                        <pre id="bdb3f"><pre id="bdb3f"><mark id="bdb3f"></mark></pre></pre><output id="bdb3f"></output><p id="bdb3f"></p><p id="bdb3f"></p>

                        <pre id="bdb3f"><del id="bdb3f"><progress id="bdb3f"></progress></del></pre>

                              <ruby id="bdb3f"></ruby>

                              哎呀哎呀视频在线观看