Package com.eatle.utils.ExcelUtil

Examples of com.eatle.utils.ExcelUtil.ExportSetInfo

90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
    List<String[]> headNames = new ArrayList<String[]>();
    headNames.add(new String[] { "用户名", "密码", "电子邮件", "类型", "角色", "所属商家" });
    List<String[]> fieldNames = new ArrayList<String[]>();
    fieldNames.add(new String[] { "userName", "pwd", "email", "typeStr", "roleStr", "merchantStr"});

    ExportSetInfo setInfo = new ExportSetInfo();
    setInfo.setObjsMap(userService.getExportData());
    setInfo.setFieldNames(fieldNames);
    setInfo.setTitles(new String[] { "馋八戒后台用户信息" });
    setInfo.setHeadNames(headNames);
    setInfo.setOut(baos);
   
    // 将需要导出的数据输出到baos
    ExcelUtil.export2Excel(setInfo);
   
    return new ByteArrayInputStream(baos.toByteArray());
View Full Code Here
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
        "法定人家庭地址", "法定人现居地址" });
    fieldNames.add(new String[]{"merchantName", "merchantPhone","merchantEmail",
        "merchantAddress","merchantJoinTime", "merchantLogoUrl","legalName",
        "legalIdCard","legalPhone","legalHomeAddress","legalAddress"});
   
    ExportSetInfo setInfo = new ExportSetInfo();
    setInfo.setObjsMap(merchantService.getExportData());
    setInfo.setFieldNames(fieldNames);
    setInfo.setTitles(new String[] { "馋八戒加盟商家信息" });
    setInfo.setHeadNames(headNames);
    setInfo.setOut(baos);
   
    // 将需要导出的数据输出到baos
    ExcelUtil.export2Excel(setInfo);
   
    return new ByteArrayInputStream(baos.toByteArray());
View Full Code Here
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
      fieldNames.add(new String[]{"name", "shopTypeStr", "contactName", "contactPhone",
          "contactEmail", "contactQq", "businessHours", "sendUpPrice",
          "address", "sendMealsDescription", "logoUrl"});
    }
   
    ExportSetInfo setInfo = new ExportSetInfo();
    setInfo.setObjsMap(objsMap);
    setInfo.setFieldNames(fieldNames);
    setInfo.setTitles(titles);
    setInfo.setHeadNames(headNames);
    setInfo.setOut(baos);
   
    // 将需要导出的数据输出到baos
    ExcelUtil.export2Excel(setInfo);
   
    return new ByteArrayInputStream(baos.toByteArray());
View Full Code Here
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
    List<String[]> headNames = new ArrayList<String[]>();
    headNames.add(new String[] { "用户名", "身份类型", "登陆IP", "登录时间" });
    List<String[]> fieldNames = new ArrayList<String[]>();
    fieldNames.add(new String[] { "userName", "identifyTypeStr", "loginIp", "loginTimeStr" });

    ExportSetInfo setInfo = new ExportSetInfo();
    setInfo.setObjsMap(loginLogService.getExportData());
    setInfo.setFieldNames(fieldNames);
    setInfo.setTitles(new String[] { "馋八戒用户登陆日志信息" });
    setInfo.setHeadNames(headNames);
    setInfo.setOut(baos);
   
    // 将需要导出的数据输出到baos
    ExcelUtil.export2Excel(setInfo);
   
    return new ByteArrayInputStream(baos.toByteArray());
View Full Code Here
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
        "联系QQ", "送餐地点", "申请时间", "审核状态", "审核时间", "审核备注"});
    List<String[]> fieldNames = new ArrayList<String[]>();
    fieldNames.add(new String[] { "shopName", "shopAddr", "linkMan", "linkTel", "linkEmail",
        "linkQq", "sendPlace", "subTimeStr", "auditStatusStr", "auditTimeStr", "auditRemark"});

    ExportSetInfo setInfo = new ExportSetInfo();
    setInfo.setObjsMap(joinInformationService.getExportData());
    setInfo.setFieldNames(fieldNames);
    setInfo.setTitles(new String[] { "馋八戒商家加盟审核信息" });
    setInfo.setHeadNames(headNames);
    setInfo.setOut(baos);
   
    // 将需要导出的数据输出到baos
    ExcelUtil.export2Excel(setInfo);
   
    return new ByteArrayInputStream(baos.toByteArray());
View Full Code Here
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
        "推荐用户", "身份类型", "推荐时间", "处理状态", "处理时间", "处理备注" });
    List<String[]> fieldNames = new ArrayList<String[]>();
    fieldNames.add(new String[] { "shopName", "shopTel", "shopAddr", "identifyStr",
        "identifyTypeStr", "subTimeStr", "handleStatusStr", "handleTimeStr", "handleRemark"});

    ExportSetInfo setInfo = new ExportSetInfo();
    setInfo.setObjsMap(recommendMerchantService.getExportData());
    setInfo.setFieldNames(fieldNames);
    setInfo.setTitles(new String[] { "馋八戒用户推荐商家信息" });
    setInfo.setHeadNames(headNames);
    setInfo.setOut(baos);
   
    // 将需要导出的数据输出到baos
    ExcelUtil.export2Excel(setInfo);
   
    return new ByteArrayInputStream(baos.toByteArray());
View Full Code Here
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
        "反馈时间", "反馈内容", "处理状态", "处理时间", "处理备注" });
    List<String[]> fieldNames = new ArrayList<String[]>();
    fieldNames.add(new String[] { "identifyStr", "identifyTypeStr", "email",
        "subTimeStr", "content", "handleStatusStr", "handleTimeStr", "handleRemark"});

    ExportSetInfo setInfo = new ExportSetInfo();
    setInfo.setObjsMap(feedbackService.getExportData());
    setInfo.setFieldNames(fieldNames);
    setInfo.setTitles(new String[] { "馋八戒用户反馈建议信息" });
    setInfo.setHeadNames(headNames);
    setInfo.setOut(baos);
   
    // 将需要导出的数据输出到baos
    ExcelUtil.export2Excel(setInfo);
   
    return new ByteArrayInputStream(baos.toByteArray());
View Full Code Here
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
    List<String[]> headNames = new ArrayList<String[]>();
    headNames.add(new String[] { "公告标题", "公告内容", "公告人", "公告时间", "公告对象" });
    List<String[]> fieldNames = new ArrayList<String[]>();
    fieldNames.add(new String[] { "title", "content", "userStr", "sendTimeStr", "targetStr" });

    ExportSetInfo setInfo = new ExportSetInfo();
    setInfo.setObjsMap(systemNoticeService.getExportData());
    setInfo.setFieldNames(fieldNames);
    setInfo.setTitles(new String[] { "馋八戒系统公告信息" });
    setInfo.setHeadNames(headNames);
    setInfo.setOut(baos);
   
    // 将需要导出的数据输出到baos
    ExcelUtil.export2Excel(setInfo);
   
    return new ByteArrayInputStream(baos.toByteArray());
View Full Code Here
60
61
62
63
64
65
66
67
68
69
70
71
72
73
      fieldNames.add(new String[]{"name", "contactName", "contactPhone",
          "contactEmail", "contactQq", "businessHours", "sendUpPrice",
          "address", "sendMealsDescription", "logoUrl"});
    }
   
    ExportSetInfo setInfo = new ExportSetInfo();
    setInfo.setObjsMap(objsMap);
    setInfo.setFieldNames(fieldNames);
    setInfo.setTitles(titles);
    setInfo.setHeadNames(headNames);
    setInfo.setOut(out);
    // 将需要导出的数据输出到baos
    ExcelUtil.export2Excel(setInfo);
  }
View Full Code Here
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
        "加盟时间", "商家Logo", "法定代表人", "法定人身份证号码", "法定人电话",
        "法定人家庭地址", "法定人现居地址" });
    fieldNames.add(new String[]{"merchantName", "merchantPhone","merchantEmail",
        "merchantAddress","merchantJoinTime", "merchantLogoUrl","legalName",
        "legalIdCard","legalPhone","legalHomeAddress","legalAddress"});
    ExportSetInfo setInfo = new ExportSetInfo();
    setInfo.setObjsMap(merchantService.getExportData());
    setInfo.setFieldNames(fieldNames);
    setInfo.setTitles(new String[] { "馋八戒加盟商家信息" });
    setInfo.setHeadNames(headNames);
    setInfo.setOut(bout);
    // 将需要导出的数据输出到baos
    ExcelUtil.export2Excel(setInfo);
   
//    OutputTo2003ExcelUtils.output("馋八戒加盟商家信息", new String[]{"merchantName",
//        "merchantPhone","merchantEmail","merchantAddress","merchantJoinTime",
View Full Code Here
TOP

Related Classes of com.eatle.utils.ExcelUtil.ExportSetInfo

  • com.eatle.service.test.merchant.MerchantTest
  • com.eatle.service.test.merchant.RestaurantTest
  • com.eatle.service.test.order.OrderTest
  • com.eatle.web.action.backend.DownloadAction
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.